Changes between Version 1 and Version 2 of TicketQuery


Ignore:
Timestamp:
09/14/17 14:49:44 (7 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • TicketQuery

    v1 v2  
    22
    33The !TicketQuery macro lets you display information on tickets within wiki pages.
    4 The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#UsingtheTicketQueryMacro TracQuery] page.
     4The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#QueryLanguage TracQuery] page.
    55
    66== Usage
    … …  
    6060|| `[[TicketQuery(created=thismonth..,count)]]` ||
    6161|-----------------------------------------------------------
     62||=Number of closed Firefox tickets: =||\
     63|| **[[TicketQuery(status=closed,keywords~=firefox,count)]]**||\
     64|| `[[TicketQuery(status=closed,keywords~=firefox,count)]]` ||
     65|-----------------------------------------------------------
     66||=Number of closed Opera tickets: =||\
     67|| **[[TicketQuery(status=closed,keywords~=opera,count)]]**||\
     68|| `[[TicketQuery(status=closed,keywords~=opera,count)]]` ||
     69|-----------------------------------------------------------
     70||=Number of closed tickets affecting Firefox and Opera: =||\
     71|| **[[TicketQuery(status=closed,keywords~=firefox opera,count)]]**||\
     72|| `[[TicketQuery(status=closed,keywords~=firefox opera,count)]]` ||
     73|-----------------------------------------------------------
     74||=Number of closed tickets affecting Firefox or Opera: =||\
     75|| **[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]**||\
     76|| `[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]` ||
     77|-----------------------------------------------------------
     78||=Number of tickets that affect Firefox or are closed and affect Opera: =||\
     79|| **[[TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count)]]**||\
     80|| `[[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]` ||
     81|-----------------------------------------------------------
     82||=Number of closed Firefox tickets that don't affect Opera: =||\
     83|| **[[TicketQuery(status=closed,keywords~=firefox - opera,count)]]**||\
     84|| `[[TicketQuery(status=closed,keywords~=firefox -opera,count)]]` ||
     85|-----------------------------------------------------------
    6286||=Last 3 modified tickets: =||\
    6387||**[[TicketQuery(max=3,order=modified,desc=1,compact)]]**||\
    … …  
    106130  [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
    107131
    108 Finally, if you wish to receive only the number of defects that match the query, use the `count` parameter:
     132If you wish to receive only the number of defects that match the query, use the `count` parameter:
    109133{{{
    110134[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
    … …  
    114138  [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
    115139
     140A graphical use of the macro is with the `format=progress` attribute:
     141{{{
     142[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
     143}}}
     144
     145For example for one of the upcoming milestones, bars are shown by ticket type:
     146[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
     147
    116148----
    117149See also: TracQuery, TracTickets, TracReports, TracGuide