TicketQuery Wiki Macro

The TicketQuery macro lets you display ticket information anywhere that accepts Wiki Formatting. 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:		[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]
owner|reporter,rows=summary,table)

Format: list

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

This is displayed as:

0.7&resolution=duplicate)

[[TicketQuery(id=123)]]

This is displayed as:

TicketQuery(id=123)

Format: compact

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

This is displayed as:

0.7&resolution=duplicate, compact)

Format: count

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

This is displayed as:

0.7&resolution=duplicate, count)

Format: progress

[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]

This is displayed as:

TicketQuery(milestone=0.12.8&group=type,format=progress)

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 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: Trac Query, Trac Tickets, Trac Reports