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)]]
|
| 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
