TicketQuery Wiki Macro
The TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.
The query language used by the [[TicketQuery]] macro is described in the TracQuery page.
Usage
Examples
| 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)]]
|
| Number of untriaged tickets (milestone unset): | TicketQuery(status!=closed,milestone=,count) | [[TicketQuery(status!=closed,milestone=,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: |
| |
Format: list
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
This is displayed as:
[[TicketQuery(id=123)]]
This is displayed as:
Format: compact
[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
This is displayed as:
Format: count
[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
This is displayed as:
Format: progress
[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
This is displayed as:
Format: table
You can choose the columns displayed in the table format (format=table) using col=<field>. You can specify multiple fields and the order they are displayed in by placing pipes (|) between the columns:
[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]
This is displayed as: summary|owner|reporter)
Full rows
In table format you can specify full rows using rows=<field>:
[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]
This is displayed as: summary|owner|reporter,rows=description)
See also: TracQuery, TracTickets, TracReports
Note:
See TracWiki
for help on using the wiki.
