Edgewall Software

Changes between Version 9 and Version 10 of TicketQuery


Ignore:
Timestamp:
Mar 15, 2014, 3:06:10 PM (10 years ago)
Author:
Peter Suter
Comment:

Add adjusted examples from wiki:0.13/TicketQuery?version=2 (#10487)

Legend:

Unmodified
Added
Removed
Modified

  • TicketQuery

    v9 v10  
    1010== Example ==
    1111
    12 
    13  * Number of [query:status=new&milestone= Triage tickets]: [[TicketQuery(status=new&milestone=, count)]]
    14  * Number of new tickets: [[TicketQuery(status=new, count)]]
    15  * Number of reopened tickets: [[TicketQuery(status=reopened, count)]]
    16  * Number of assigned tickets: [[TicketQuery(status=assigned, count)]]
    17  * Number of invalid tickets: [[TicketQuery(status=closed&resolution=invalid, count)]]
    18  * Number of worksforme tickets: [[TicketQuery(status=closed&resolution=worksforme, count)]]
    19  * Number of duplicate tickets: [[TicketQuery(status=closed&resolution=duplicate, count)]]
    20  * Number of wontfix tickets: [[TicketQuery(status=closed&resolution=wontfix, count)]]
    21  * Number of fixed tickets: [[TicketQuery(status=closed&resolution=fixed, count)]]
    22  * Total number of tickets in Trac is [[TicketQuery(status=new|assigned|reopened|closed, count)]]
    23  * Number of active tickets reported by '''or''' owned by the current user: [[TicketQuery(status!=closed,reporter=$USER,or,owner=$USER,status!=closed, count)]]
     12||= **Example** =||= **Result** =||= **Macro** =||
     13|-----------------------------------------------------------
     14||=Number of [query:status=new&milestone= Triage tickets]: =||\
     15||**[[TicketQuery(status=new&milestone=,count)]]**||\
     16|| `[[TicketQuery(status=new&milestone=,count)]]` ||
     17|-----------------------------------------------------------
     18||=Number of new tickets: =||\
     19||**[[TicketQuery(status=new,count)]]**||\
     20|| `[[TicketQuery(status=new,count)]]` ||
     21|-----------------------------------------------------------
     22||=Number of reopened tickets: =||\
     23||**[[TicketQuery(status=reopened,count)]]**||\
     24|| `[[TicketQuery(status=reopened,count)]]` ||
     25|-----------------------------------------------------------
     26||=Number of assigned tickets: =||\
     27||**[[TicketQuery(status=assigned,count)]]**||\
     28|| `[[TicketQuery(status=assigned,count)]]` ||
     29|-----------------------------------------------------------
     30||=Number of invalid tickets: =||\
     31||**[[TicketQuery(status=closed,resolution=invalid,count)]]**||\
     32|| `[[TicketQuery(status=closed,resolution=invalid,count)]]` ||
     33|-----------------------------------------------------------
     34||=Number of worksforme tickets: =||\
     35||**[[TicketQuery(status=closed,resolution=worksforme,count)]]**||\
     36|| `[[TicketQuery(status=closed,resolution=worksforme,count)]]` ||
     37|-----------------------------------------------------------
     38||=Number of duplicate tickets: =||\
     39||**[[TicketQuery(status=closed,resolution=duplicate,count)]]**||\
     40|| `[[TicketQuery(status=closed,resolution=duplicate,count)]]` ||
     41|-----------------------------------------------------------
     42||=Number of wontfix tickets: =||\
     43||**[[TicketQuery(status=closed,resolution=wontfix,count)]]**||\
     44|| `[[TicketQuery(status=closed,resolution=wontfix,count)]]` ||
     45|-----------------------------------------------------------
     46||=Number of fixed tickets: =||\
     47||**[[TicketQuery(status=closed,resolution=fixed,count)]]**||\
     48|| `[[TicketQuery(status=closed,resolution=fixed,count)]]` ||
     49|-----------------------------------------------------------
     50||=Total number of tickets: =||\
     51||**[[TicketQuery(count)]]**||\
     52|| `[[TicketQuery(count)]]` ||
     53|-----------------------------------------------------------
     54||=Number of tickets reported **or** owned by current user: =||\
     55||**[[TicketQuery(reporter=$USER,or,owner=$USER,count)]]**||\
     56|| `[[TicketQuery(reporter=$USER,or,owner=$USER,count)]]` ||
     57|-----------------------------------------------------------
     58||=Number of tickets created this month: =||\
     59||**[[TicketQuery(created=thismonth..,count)]]**||\
     60|| `[[TicketQuery(created=thismonth..,count)]]` ||
     61|-----------------------------------------------------------
     62||=Last 3 modified tickets: =||\
     63||**[[TicketQuery(max=3,order=modified,desc=1,compact)]]**||\
     64|| `[[TicketQuery(max=3,order=modified,desc=1,compact)]]` ||
     65|-----------------------------------------------------------
     66{{{#!th rowspan=2, style="text-align: left;"
     67Details of ticket #1:
     68}}}
     69{{{#!td style="border-bottom: 0;"
     70}}}
     71{{{#!td
     72`[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]`
     73}}}
     74|-
     75{{{#!td colspan=2, style="border-top: 0;"
     76[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]
     77}}}
     78|-----------------------------------------------------------
    2479
    2580