%.*s %d wiki_%d: tkt_%d: chng_%d: %s%s %s%d wiki tkt chng select The SQL must be a SELECT statement Semi-colon detected! Only a single SQL statement is allowed 0 rn SELECT title, sqlcode, owner, cols FROM reportfmt WHERE rn=%d rptview?rn=%d View SQL For Report Format Number %d
Unknown report number: %d
Title:
%h
Owner:
%h
SQL:
%h
border=0 cellspacing=0 cellpadding=3
t w s k del2 DELETE FROM reportfmt WHERE rn=%d del1 SELECT title FROM reportfmt WHERE rn=%d Cancel Are You Sure?
can Please supply an SQL query statement Please supply a title %s UPDATE reportfmt SET title='%q', sqlcode='%q', owner='%q', cols='%q' WHERE rn=%d INSERT INTO reportfmt(title,sqlcode,owner,cols) VALUES('%q','%q','%q','%q') SELECT max(rn) FROM reportfmt SELECT
CASE WHEN status IN ('new','active') THEN '#f2dcdc'
WHEN status='review' THEN '#e8e8bd'
WHEN status='fixed' THEN '#cfe8bd'
WHEN status='tested' THEN '#bde5d6'
WHEN status='defer' THEN '#cacae5'
ELSE '#c8c8c8' END AS 'bgcolor',
tn AS '#',
type AS 'Type',
status AS 'Status',
sdate(origtime) AS 'Created',
owner AS 'By',
subsystem AS 'Subsys',
sdate(changetime) AS 'Changed',
assignedto AS 'Assigned',
severity AS 'Svr',
priority AS 'Pri',
title AS 'Title'
FROM ticket
#ffffff Key:
#f2dcdc Active
#e8e8e8 Review
#cfe8bd Fixed
#bde5d6 Tested
#cacae5 Deferred
#c8c8c8 Closed
copy Copy Of %s rptedit?rn=%d&del1=1 Delete Edit Report Format Create New Report Format
%h
TICKET Schema
CREATE TABLE ticket(
tn integer primary key, -- Unique tracking number for the ticket
type text, -- code, doc, todo, new, or event
status text, -- new, review, defer, active, fixed,
-- tested, or closed
origtime int, -- Time this ticket was first created
changetime int, -- Time of most recent change to this ticket
derivedfrom int, -- This ticket derived from another
version text, -- Version or build number
assignedto text, -- Whose job is it to deal with this ticket
severity int, -- How bad is the problem
priority text, -- When should the problem be fixed
subsystem text, -- What subsystem does this ticket refer to
owner text, -- Who originally wrote this ticket
title text, -- Title of this bug
description text, -- Description of the problem
remarks text -- How the problem was dealt with
);
Notes
The SQL must consist of a single SELECT statement
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.
If a column of the result set is named "bgcolor" then the content
of that column determines the background color of the row.
Times in the TICKET table are expressed as seconds since 1970.
Convert these values to human-friendly date formats using the
sdate() and ldate() SQL functions.
The now() SQL function returns the current time and date
in seconds since 1970. The user() SQL function returns a string
which is the login of the current user.
The first column whose name begins with underscore ("_") and all
subsequent columns are shown on their own rows in the table. This is
useful for displaying the TICKET.DESCRIPTION and TICKET.REMARKS fields.
The aux() SQL function takes a parameter name as an argument
and returns the value that the user enters in the resulting HTML form. A
second optional parameter provides a default value for the field.
The option() SQL function takes a parameter name
and a quoted SELECT statement as parameters. The query results are
presented as an HTML dropdown menu and the function returns
the currently selected value. Results may be a single value column or
two value,description columns. The first row is the default.
The cgi() SQL function takes a parameter name as an argument
and returns the value of a corresponding CGI query value. If the CGI
parameter doesn't exist, an optional second argument will be returned
instead.
If a column is wrapped by the wiki() SQL function, it will
be rendered as wiki formatted content.
If a column is wrapped by the tkt() SQL function, it will
be shown as a ticket number with a link to the appropriate page
If a column is wrapped by the chng() SQL function, it will
be shown as a checkin number with a link to the appropriate page.
The path() SQL function can be used to extract complete filename
from FILE table. For example:
SELECT path(isdir, dir, base) AS 'filename' FROM file
The dirname() SQL function takes filename as only argument
and extracts parent directory name from it.
The basename() SQL function takes filename as only argument
and extracts basename from it.
The search() SQL function takes a keyword pattern and
a search text. The function returns an integer score which is
higher depending on how well the search went.
The query can join other tables in the database besides TICKET.
Examples
In this example, the first column in the result set is named
"bgcolor". The value of this column is not displayed. Instead, it
selects the background color of each row based on the TICKET.STATUS
field of the database. The color key at the right shows the various
color codes.
new or active
review
fixed
tested
defer
closed
SELECT
CASE WHEN status IN ('new','active') THEN '#f2dcdc'
WHEN status='review' THEN '#e8e8bd'
WHEN status='fixed' THEN '#cfe8bd'
WHEN status='tested' THEN '#bde5d6'
WHEN status='defer' THEN '#cacae5'
ELSE '#c8c8c8' END as 'bgcolor',
tn AS '#',
type AS 'Type',
status AS 'Status',
sdate(origtime) AS 'Created',
owner AS 'By',
subsystem AS 'Subsys',
sdate(changetime) AS 'Changed',
assignedto AS 'Assigned',
severity AS 'Svr',
priority AS 'Pri',
title AS 'Title'
FROM ticket
To base the background color on the TICKET.PRIORITY or
TICKET.SEVERITY fields, substitute the following code for the
first column of the query:
1
2
3
4
5
SELECT
CASE priority WHEN 1 THEN '#f2dcdc'
WHEN 2 THEN '#e8e8bd'
WHEN 3 THEN '#cfe8bd'
WHEN 4 THEN '#cacae5'
ELSE '#c8c8c8' END as 'bgcolor',
...
FROM ticket
To see the TICKET.DESCRIPTION and TICKET.REMARKS fields, include
them as the last two columns of the result set and given them names
that begin with an underscore. Like this:
SELECT
tn AS '#',
type AS 'Type',
status AS 'Status',
sdate(origtime) AS 'Created',
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.
FROM ticket
Or, to see part of the description on the same row, use the
wiki() function with some string manipulation. Using the
tkt() function on the ticket number will also generate a linked
field, but without the extra edit column:
SELECT
tkt(tn) AS '',
title AS 'Title',
wiki(substr(description,0,80)) AS 'Description'
FROM ticket
SELECT tool.name FROM tool,user WHERE tool.object='rpt' AND user.id='%q' AND cap_and(tool.perms,user.capabilities)!='' rptrool?t=%T&rn=%d index SELECT command FROM tool WHERE name='%q' AND object='rpt' rptsql?rn=%d SQL %h (%d) RN tablist rptview QUERY_STRING rptview?tablist=1&%s Raw Data rptedit?rn=%d Edit border=0 cellpadding=3 cellspacing=0
text/plain ` ⍀` PΧɧK ⍀K P鵧谧6 ⍀6 P霧藧! ⍀! P郧~ ⍀ Pje ⍀ PQL ⍀ P83 ⍀ P ⍀ P ⍀ P ⍀ PԦϦy ⍀y P黦趦d ⍀d P颦蝦O ⍀O P鉦脦: ⍀: Ppk% ⍀% PWR ⍀ P>9 ⍀ P% ⍀ P ⍀ P ⍀ Pڥե ⍀ P輥 ⍀ P騥裥} ⍀} P鏥芥h ⍀h PvqS ⍀S P]X> ⍀> PD?) ⍀) P+& ⍀ P
⍀ P ⍀ Pۤ ⍀ PǤ¤ ⍀ P鮤詤 ⍀ P镤萤 ⍀ P|w ⍀ Pc^l ⍀l PJEW ⍀W P1,B ⍀B P- ⍀- P ⍀ P ⍀ Pͣȣ ⍀ P鴣诣 ⍀ P難薣 ⍀ P那&X ?X XX qX X X X X X Y Y 9Y RY kY Y Y Y Y Y Z Z 3Z LZ eZ ~Z Z Z Z Z Z [ -[ F[ _[ x[ [ [ [ [ [ \ '\ @\ Y\ r\ $Ë $$ 8] $ $
$ \$ 8] P$ L$
7$ ,$ $$ X P! $ $ $ $ P! # ;- P! # # # T P! # # # $ P! # ;- P! # # # W P! |# e# W P! _# W# ;- P! J# ># 'W P! 6# .# W P! !# # W P!
# # qW P! " " 4] P! " 4] P! " 4] P! " " hW P! " " SW P! " " FW P! " " O% P! |" t" >W P! f" ^" @U P! " " +% P! " ! `( P! ! ! ! ! 6W P! ! ! +% P! ! ! ! >( P! ! <( P! ! k! ^! 4] P! X! L!
5! 0! (! ! (
! n' ~ 3W p h +W T B 6 'W . & W
( ( ( V t g 4] a \ T V 5 - * >( <(
V : 2 @V # 4]
^ V $ ;- U m' g _ @U $ ^ U ^
T R T U M T z N F T 9 1 UR % xT
uT U M uT %
qT m' v n h' ;
R S 4] jT t l WT d \ 9T L D T ) n' S w S [ 4] 6 m' _S YS S R } u R o g [R S 4] B : R R [R 4] p h UR b Z R I A Q 4] 4] 4] 4] 4] 4] n 4] h ` Q @ 4] + 4] 4] 4] `Q 4] R 4] HQ >( <( {
c [ DQ h L D 9 * y q i d
P H M 8 B : `5 8 4
" >5
5 4 `4 4] 4] @3 ~ 3 o g 2 a Q * = 5 2 , $ 2 4] 1 1 0 0 O% 0 0 p h +% ^ H+ P 4] < 4] 3 + 0 0 `( @0 . m' y ( i [ S - M E - ! @-
;-
;-
u
%- d
Q
- *
"
+%
, `+ O+ H+ ( +% + q i + L D +% > 6 * % * * m' * * 4] * n f ^ >( T <( N I D + 4]
*
*
) r
m
e
( P
H
( ;
/
( '
(
O%
`( >( <( 4]
X P ( 2 ' '
s d ' @ % * ' % ' %
| q L D ' 1 )
'
y T L ' 9 )
] ] ' ]
] ] z' ] |
j `] 4 d \ `] 4 J q' 4 @ 6 `] 4 0
H @ h'
m' w o n' e H $ m'
h'
m h ` a' Z R ' D 4] 3 + & & 4] 4] 4] `& u 4] o g L& 4] & % % ]% } O% w o H% e 6% W 4] Q I +% ? % 9 4]
a $
[ .] j\ S .] j\ M
H $
B *] Q\ : *] Q\ 4
/ $
) &] 8\ ! &] 8\
$
"] \ "] \
$
] \ ] \
$
] [ ] [
$
] [ ] [
$
] [ ] [
$
] [ ] [
$
z
] [ r
] [ l
g $
a ] p[ Y ] p[ S
N $
H ] W[ @ ] W[ :
5 $
/ \ >[ ' \ >[ !
$
\ %[ \ %[
$
\ [ \ [
$
\ Z \ Z
$
\ Z \ Z
$
\ Z \ Z
$
\ Z \ Z
$
\ Z x \ Z r
m $
g \ vZ _ \ vZ Y
T $
N \ ]Z F \ ]Z @
; $
5 \ DZ - \ DZ '
" $
\ +Z \ +Z
$
\ Z \ Z
$
\ Y \ Y
$
\ Y \ Y
$
\ Y \ Y
$
\ Y \ Y
$
\ Y ~ \ Y x
s $
m \ |Y e \ |Y _
Z $
T \ cY L \ cY F
A $
; \ JY 3 \ JY -
( $
" \ 1Y \ 1Y
$
\ Y \ Y
$
\ X \ X
$
\ X \ X
$
\ X \ X
$
\ X \ X
$
\ X \ X ~
y $
s \ X k \ X e
` $
Z \ iX R \ iX L
G $
A \ PX 9 \ PX 3
. $
( \ 7X \ 7X
$
~\ X ~\ X
| x t p l h d ` \ X T P L H D @ < 8 4 0 , ( $ "
g !
# "
g !
# d d < D$ D( D) D* ) D+ = D, U D- c D/ { D0 D1 D2 D4 D5 D7 D8 N D: s D; D= D> D@ D4 7 DC B DD P DF ^ DG l DH q $$ % # & J U V w W $ x DM x DN DO X D$ DP DQ DR DS b $M x u M N $ DX DY DZ . $ D[ V D` ^ Db Dc $X X $ Dj Dm Dn Do Dp - Dq O Dr m Ds Dt Du Dv Dy Dq D{ D| D} $j j k k k
l & $ `] ( D ( D 4 D ? D h D n & $ ( 6 ( `] x 4 t $ L ] t D t D D D D $ t ( ] $ L ] D D D D D $ ( ] $ L D D D D 0 D 8 D [ D } D $ , ^ j $ D D D D D D D $
$ | D D D D 0 D S D u D $ + 8 D M N O $ | P D D D D D . D w d $ ~ } $ D D D D D D D D D + D 9 D H D N D a D i D p $ d p $ D | D D D D D D D D D
D
D?
DT
D\
Dq
Dv
D
{
D
D
D
D
D
D
D
D
D
$ | ! . < E F G $ D# D* D, D- D.* D// D14 D2H D3M D4R D5u D6 D7 D8 D9 D:
D;- D<B D=P D>U D?} DA DC DD DE DO DP
DQ
DS
DT.
DV3
DWG
DXO
DY]
DZs
D[~
D_
D`
Da
Db
Dd
De
Df
Dj' DmQ Dnb Dpp Dq Ds Dt Du D D D D D D D D D D" D: DH D\ Dt Dz D D D D D D D" D3 DA De Du D D D D D D D D D D D D! D& H $# Y $b %o &w ' ( ) * _
H " s , $ ( , D, D8 DyF DT $, $ 0 \ D\ Dh Dp Dx D D D D D
D2 DR Dg $\ 6 C O [ g h h m i $ j p Dp D D D D D D D D D D DH DN DP Du D{ D D D D D D D D D D D) D> DW Dl D D D D DM DX Df Dt D{ D D D D D D D D D D D " DF D Q D
e Ds D D D D D D D" D# D$ D% D& D( D) D*. D+= D,S D-g D. D0 D1 D2 D4 D5 D6 D7- D8R D9Z D;j D<x D= D& D@ DA DC DD DE y $p
#
-
7
W
X
a
j
k
P l
x
y
I z
'
$
DK DL DN DOX DP^ DRz DS DT DV DX
$K
K
M
M
$
Db Dc Df Dg Dh Di) DgY Dla Dmg Dnx Do Dm Dq Dr
$b
^ _ ` % b 3 cA dI J K $ Dw Dy Dz D{ D| D}) D~/ D= D[ Dh D D D D! D' D[ D D D D D D L $w d w s w w x x x y y $ ^ D D D D D D D D" D+ D3 DA DG DR D] Dk D D D D D D
$ . 7 B O ] & ^ k l m $ @ n D D D! DA Db D D D D } $ $ D D D# D< DF D` De D} D D D D D D D DF DX Dt D D D D! D ! D! D4! D9! $
h$
d,
-
C! .
$ T DD! DP! DW! D\! Dt! D ! D ! D ! D ! D!! D"! D#! D$! D&" D'" D( " D*"" D+*" D,5" D-@" D.K" D/R" D0\" D1j" D2" D3" D7" D8" D:%# D;N# D<c# D=# D># D?# D@# DA# DC# DD# DE$ DF"$ DH0$ DI6$ DK;$ /
$D! @
L
U
^
i
v
P!
A$
$
D D$ D P$ D $
$ D$
@ $ h D $ D $ D $ $ $ & 1 $ L 2 d $ <] @] 1 B $ x V z l | D! w
N 0 ; U q + ^ P a } n + < w ^ F _view_list ___i686.get_pc_thunk.bx _trim_string _extract_integer _remove_blank_lines _verify_sql_statement _view_see_sql _view_edit _output_color_key _embed_view _rpttool _view_view ___i686.get_pc_thunk.ax dyld_stub_binding_helper _g __DefaultRuneLocale _cgi_set_content_type _getenv _execute_tool _history_update _db_callback_query _cgi_v_optionmenu2 _output_chng _output_ticket _output_formatted _strncmp _cgi_v_optionmenu _db_query_check _db_restrict_access _db_short_query _cgi_redirect _db_execute _db_add_functions _cgi_parameter _sqlite3_complete _sqlite3StrNICmp _sqlite3_create_function _db_open _sqlite3_value_int _free _sqlite3_result_text _sqlite3_value_text _bprintf _rand _atoi _mprintf _strlen _common_footer _strcmp _cgi_printf _db_query _common_header _common_add_help_item _common_add_action_item _common_standard_menu _throttle _login_needed _login_check_credentials ___maskrune /mnt/gmirror/ports/devel/cvstrac/work/cvstrac-2.0.0/ view_.c gcc2_compiled. view_list:F(0,1)=(0,1) void:t(0,1) az:(0,2)=*(0,3)=*(0,4)=r(0,4);0;127; char:t(0,4) i:(0,5)=r(0,5);-2147483648;2147483647; int:t(0,5) ___istype trim_string:F(0,3) zOrig:p(0,6)=*(0,7)=k(0,4) i:(0,5) ___isctype extract_integer:F(0,3) zOrig:p(0,6) remove_blank_lines:F(0,3) zOrig:p(0,6) i:(0,5) j:(0,5) n:(0,5) z:(0,3) _key.0 _wiki_key wiki_key:f(0,6) key:V(0,8)=ar(0,9)=r(0,9);0000000000000;0037777777777;;0;63;(0,4) long unsigned int:t(0,10)=r(0,10);0000000000000;0037777777777; _key.1 _tkt_key tkt_key:f(0,6) key:V(0,8) _key.2 _chng_key chng_key:f(0,6) key:V(0,8) _f_wiki f_wiki:f(0,1) context:p(0,11)=*(0,12)=(0,13)=xssqlite3_context: argc:p(0,5) argv:p(0,14)=*(0,15)=*(0,16)=(0,17)=xsMem: zText:(0,3) _f_tkt f_tkt:f(0,1) context:p(0,11) argc:p(0,5) argv:p(0,14) zText:(0,3) tn:(0,5) _f_chng f_chng:f(0,1) context:p(0,11) argc:p(0,5) argv:p(0,14) zText:(0,3) cn:(0,5) _view_add_functions view_add_functions:f(0,1) db:(0,18)=*(0,19)=(0,20)=xssqlite3: verify_sql_statement:F(0,3) zSql:p(0,3) i:(0,5) bad:(0,5) c:(0,5) view_see_sql:F(0,1) rn:(0,5) zTitle:(0,3) zSQL:(0,3) zOwner:(0,3) zClrKey:(0,3) az:(0,2) view_edit:F(0,1) rn:(0,5) zTitle:(0,6) z:(0,6) zOwner:(0,6) zClrKey:(0,3) zSQL:(0,3) zErr:(0,3) access:(0,5) az:(0,2) azUsers:(0,2) _report_format_hints report_format_hints:f(0,1) _output_report_field output_report_field:f(0,1) zData:p(0,6) zWkey:(0,6) zTkey:(0,6) zCkey:(0,6) _generate_html generate_html:f(0,5) pUser:p(0,21)=*(0,1) nArg:p(0,5) azArg:p(0,2) azName:p(0,2) pCount:(0,22)=*(0,5) i:(0,5) tn:(0,5) rn:(0,5) ncol:(0,5) multirow:(0,5) newrowidx:(0,5) iBg:(0,5) zBg:(0,3) zPage:(0,23)=ar(0,9);0;29;(0,4) zN:(0,6) zP:(0,6) zName:(0,3) zData:(0,3) _output_no_tabs output_no_tabs:f(0,1) z:p(0,6) i:(0,5) j:(0,5) _output_tab_separated output_tab_separated:f(0,5) pUser:p(0,21) nArg:p(0,5) azArg:p(0,2) azName:p(0,2) pCount:(0,22) i:(0,5) output_color_key:F(0,1) zClrKey:p(0,6) horiz:p(0,5) zTabArgs:p(0,3) i:(0,5) j:(0,5) k:(0,5) zSafeKey:(0,3) zToFree:(0,3) _nDepth.3 embed_view:F(0,1) rn:p(0,5) zCaption:p(0,6) zTableOpts:p(0,6) count:(0,5) last_access:(0,5) az:(0,2) zSql:(0,3) zTitle:(0,6) zClrKey:(0,3) nDepth:V(0,5) _add_rpt_tools add_rpt_tools:f(0,1) zExcept:p(0,6) rn:p(0,5) i:(0,5) zLink:(0,3) azTools:(0,2) rpttool:F(0,1) rn:(0,5) zTool:(0,6) zAction:(0,3) azSubst:(0,24)=ar(0,9);0;31;(0,6) n:(0,5) view_view:F(0,1) count:(0,5) rn:(0,5) az:(0,2) zSql:(0,3) zTitle:(0,3) zOwner:(0,3) zClrKey:(0,3) tabs:(0,5) access:(0,5) /usr/include/ctype.h __istype:f(0,5) _c:p(0,25)=(0,5) _f:p(0,10) __darwin_ct_rune_t:t(0,25) __isctype:f(0,25) _c:p(0,25) _f:p(0,10)