Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | On the <tt>/rptsql</tt> page wrap a report's source code and the tickets schema with CODE elements having class="language-sql". |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
d3ca01a81e5778b1ffa5b7a850ea43e4 |
| User & Date: | george 2021-06-17 22:51:51.077 |
Context
|
2021-06-17
| ||
| 23:34 | Amend "Interwiki Tag Map" heading at the bottom of [/md_rules] and [/wiki_rules] pages: turn the word "Map" into a link to the [/intermap] page. ... (check-in: 5061599031 user: george tags: trunk) | |
| 22:51 | On the <tt>/rptsql</tt> page wrap a report's source code and the tickets schema with CODE elements having class="language-sql". ... (check-in: d3ca01a81e user: george tags: trunk) | |
| 02:20 | /announce page: add an explicit ACTION value for the form so that a 'to=...' URL parameter does not end up shadowing the 'to' field of the form and causing the announcement to be sent to the URL-provided address even if that form field is edited. ... (check-in: 2fa43ef4fb user: stephan tags: trunk) | |
Changes
Changes to src/report.c.
| ︙ | ︙ | |||
350 351 352 353 354 355 356 | @ <table cellpadding=0 cellspacing=0 border=0> @ <tr><td valign="top" align="right">Title:</td><td width=15></td> @ <td colspan="3">%h(zTitle)</td></tr> @ <tr><td valign="top" align="right">Owner:</td><td></td> @ <td colspan="3">%h(zOwner)</td></tr> @ <tr><td valign="top" align="right">SQL:</td><td></td> @ <td valign="top"><pre> | | | 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 | @ <table cellpadding=0 cellspacing=0 border=0> @ <tr><td valign="top" align="right">Title:</td><td width=15></td> @ <td colspan="3">%h(zTitle)</td></tr> @ <tr><td valign="top" align="right">Owner:</td><td></td> @ <td colspan="3">%h(zOwner)</td></tr> @ <tr><td valign="top" align="right">SQL:</td><td></td> @ <td valign="top"><pre> @ <code class="language-sql">%h(zSQL)</code> @ </pre></td> @ <td width=15></td><td valign="top"> output_color_key(zClrKey, 0, "border=0 cellspacing=0 cellpadding=3"); @ </td> @ </tr></table> report_format_hints(); style_finish_page(); |
| ︙ | ︙ | |||
535 536 537 538 539 540 541 |
zSchema = db_text(0,"SELECT sql FROM sqlite_schema WHERE name='ticket'");
if( zSchema==0 ){
zSchema = db_text(0,"SELECT sql FROM repository.sqlite_schema"
" WHERE name='ticket'");
}
@ <hr /><h3>TICKET Schema</h3>
@ <blockquote><pre>
| | | 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 |
zSchema = db_text(0,"SELECT sql FROM sqlite_schema WHERE name='ticket'");
if( zSchema==0 ){
zSchema = db_text(0,"SELECT sql FROM repository.sqlite_schema"
" WHERE name='ticket'");
}
@ <hr /><h3>TICKET Schema</h3>
@ <blockquote><pre>
@ <code class="language-sql">%h(zSchema)</code>
@ </pre></blockquote>
@ <h3>Notes</h3>
@ <ul>
@ <li><p>The SQL must consist of a single SELECT statement</p></li>
@
@ <li><p>If a column of the result set is named "#" then that column
@ is assumed to hold a ticket number. A hyperlink will be created from
|
| ︙ | ︙ |