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:		[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]
	owner|reporter,rows=summary,table)?

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:

0.7&resolution=duplicate)?

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:

TicketQuery(id=123)?

A more compact representation without the ticket summaries is:

[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]

This is displayed as:

0.7&resolution=duplicate, compact)?

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:

0.7&resolution=duplicate, count)?

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