wiki:TicketQuery

Version 1 (modified by trac, 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)]]
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