path: root/raw-wiki-dump/TicketQuery.md

   
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#UsingtheTicketQueryMacro TracQuery] page.
Usage
[[MacroList(TicketQuery)]]
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)]] |
|-----------------------------------------------------------
```#!th rowspan=2, style="text-align: left;"
Details of ticket #1:
```#!td style="border-bottom: 0;"


``#!td[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]`
|-
```#!td colspan=2, style="border-top: 0;"
[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]


|-----------------------------------------------------------
Using the [[TicketQuery]] Macro
The [trac:TicketQuery 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:
  [[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
Just like the [wiki:TracQuery#UsingTracLinks query: wiki links], the parameter of this macro expects a query string formatted according to the rules of the simple [wiki:TracQuery#QueryLanguage 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:
  [[TicketQuery(version=0.6|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:
  [[TicketQuery(version=0.6|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