| Version 1 (modified by , 7 years ago) (diff) |
|---|
TicketQuery Wiki Macro
The TicketQuery macro lets you display information on tickets within wiki pages.
The query language used by the [[TicketQuery]] macro is described in TracQuery page.
Usage
Example
| Example | Result | Macro |
|---|---|---|
| Number of [query:status=new&milestone= Triage tickets]: | TicketQuery(status=new&milestone=,count)? | [[TicketQuery(status=new&milestone=,count)]]
|
| Number of new tickets: | TicketQuery(status=new,count)? | [[TicketQuery(status=new,count)]]
|
| Number of reopened tickets: | TicketQuery(status=reopened,count)? | [[TicketQuery(status=reopened,count)]]
|
| Number of assigned tickets: | TicketQuery(status=assigned,count)? | [[TicketQuery(status=assigned,count)]]
|
| Number of invalid tickets: | TicketQuery(status=closed,resolution=invalid,count)? | [[TicketQuery(status=closed,resolution=invalid,count)]]
|
| Number of worksforme tickets: | TicketQuery(status=closed,resolution=worksforme,count)? | [[TicketQuery(status=closed,resolution=worksforme,count)]]
|
| Number of duplicate tickets: | TicketQuery(status=closed,resolution=duplicate,count)? | [[TicketQuery(status=closed,resolution=duplicate,count)]]
|
| Number of wontfix tickets: | TicketQuery(status=closed,resolution=wontfix,count)? | [[TicketQuery(status=closed,resolution=wontfix,count)]]
|
| Number of fixed tickets: | TicketQuery(status=closed,resolution=fixed,count)? | [[TicketQuery(status=closed,resolution=fixed,count)]]
|
| Total number of tickets: | TicketQuery(count)? | [[TicketQuery(count)]]
|
| Number of tickets reported or owned by current user: | TicketQuery(reporter=$USER,or,owner=$USER,count)? | [[TicketQuery(reporter=$USER,or,owner=$USER,count)]]
|
| Number of tickets created this month: | TicketQuery(created=thismonth..,count)? | [[TicketQuery(created=thismonth..,count)]]
|
| Number of closed Firefox tickets: | TicketQuery(status=closed,keywords~=firefox,count)? | [[TicketQuery(status=closed,keywords~=firefox,count)]]
|
| Number of closed Opera tickets: | TicketQuery(status=closed,keywords~=opera,count)? | [[TicketQuery(status=closed,keywords~=opera,count)]]
|
| Number of closed tickets affecting Firefox and Opera: | TicketQuery(status=closed,keywords~=firefox opera,count)? | [[TicketQuery(status=closed,keywords~=firefox opera,count)]]
|
| Number of closed tickets affecting Firefox or Opera: | opera,count)? | [[TicketQuery(status=closed,keywords~=firefox|opera,count)]]
|
| Number of tickets that affect Firefox or are closed and affect Opera: | TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count)? | [[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]
|
| Number of closed Firefox tickets that don't affect Opera: | TicketQuery(status=closed,keywords~=firefox - opera,count)? | [[TicketQuery(status=closed,keywords~=firefox -opera,count)]]
|
| Last 3 modified tickets: | TicketQuery(max=3,order=modified,desc=1,compact)? | [[TicketQuery(max=3,order=modified,desc=1,compact)]]
|
Details of ticket #1: |
| |
Using the [[TicketQuery]] Macro
The TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.
Example:
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
This is displayed as:
Just like the query: wiki links, the parameter of this macro expects a query string formatted according to the rules of the simple ticket query language. This also displays the link and description of a single ticket:
[[TicketQuery(id=123)]]
This is displayed as:
A more compact representation without the ticket summaries is:
[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
This is displayed as:
If you wish to receive only the number of defects that match the query, use the count parameter:
[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
This is displayed as:
A graphical use of the macro is with the format=progress attribute:
[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
For example for one of the upcoming milestones, bars are shown by ticket type: TicketQuery(milestone=0.12.8&group=type,format=progress)?
See also: TracQuery, TracTickets, TracReports, TracGuide
