610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
|
@ assignedto AS 'Assigned',
@ severity AS 'Svr',
@ priority AS 'Pri',
@ title AS 'Title',
@ 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:
@ </p>
@ <blockquote><pre>
@ SELECT
@ tkt(tn) AS '',
@ title AS 'Title',
@ wiki(substr(description,0,80)) AS 'Description'
@ FROM ticket
@ </pre></blockquote>
@
}
/*
** The state of the report generation.
*/
|
<
<
<
<
<
<
<
<
<
<
<
<
<
|
610
611
612
613
614
615
616
617
618
619
620
621
622
623
|
@ assignedto AS 'Assigned',
@ severity AS 'Svr',
@ priority AS 'Pri',
@ title AS 'Title',
@ description AS '_Description', -- When the column name begins with '_'
@ remarks AS '_Remarks' -- content is rendered as wiki
@ FROM ticket
@ </pre></blockquote>
@
}
/*
** The state of the report generation.
*/
|