486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
|
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
|
+
+
+
+
+
-
-
+
+
+
+
|
@
@ <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
@ that column to a detailed view of the ticket.</p></li>
@
@ <li><p>If a column of the result set is named "bgcolor" then the content
@ of that column determines the background color of the row.</p></li>
@
@ <li><p>The text of all columns prior to the first column whose name begins
@ with underscore ("_") is shown character-for-character as it appears in
@ the database. In other words, it is assumed to have a mimetype of
@ text/plain.
@
@ <li><p>The first column whose name begins with underscore ("_") and all
@ subsequent columns are shown on their own rows in the table. This might
@ be useful for displaying the description of tickets.
@ subsequent columns are shown on their own rows in the table and with
@ wiki formatting. In other words, such rows are shown with a mimetype
@ of text/x-fossil-wiki. This is recommended for the "description" field
@ of tickets.
@ </p></li>
@
@ <li><p>The query can join other tables in the database besides TICKET.
@ </p></li>
@ </ul>
@
@ <h3>Examples</h3>
|
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
|
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
|
-
-
+
+
|
@ owner AS 'By',
@ subsystem AS 'Subsys',
@ sdate(changetime) AS 'Changed',
@ assignedto AS 'Assigned',
@ severity AS 'Svr',
@ priority AS 'Pri',
@ title AS 'Title',
@ description AS '_Description', -- When the column name begins with '_'
@ remarks AS '_Remarks' -- the data is shown on a separate row.
@ description AS '_Description', -- When the column name begins with '_'
@ remarks AS '_Remarks' -- content is rendered as wiki
@ FROM ticket
@ </pre></blockquote>
@
@ <p>Or, to see part of the description on the same row, use the
@ <b>wiki()</b> function with some string manipulation. Using the
@ <b>tkt()</b> function on the ticket number will also generate a linked
@ field, but without the extra <i>edit</i> column:
|
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
|
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
|
+
-
+
|
if( pState->iNewRow>=0 && i>=pState->iNewRow ){
if( zTid && g.perm.Write ){
@ <td valign="top">%z(href("%R/tktedit/%h",zTid))edit</a></td>
zTid = 0;
}
if( zData[0] ){
Blob content;
@ </tr>
@ </tr><tr style="background-color:%h(zBg)"><td colspan=%d(pState->nCol)>
@ <tr style="background-color:%h(zBg)"><td colspan=%d(pState->nCol)>
blob_init(&content, zData, -1);
wiki_convert(&content, 0, WIKI_NOBADLINKS);
blob_reset(&content);
}
}else if( azName[i][0]=='#' ){
zTid = zData;
@ <td valign="top">%z(href("%R/tktview?name=%h",zData))%h(zData)</a></td>
|