====== 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)]]]` |
|-----------------------------------------------------------
<code>#!th rowspan=2, style="text-align: left;"
Details of ticket #1:
</code>

<code>#!td style="border-bottom: 0;"
</code>

<code>#!td
`[[:[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]]`
</code>

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

|-----------------------------------------------------------

===== Using the `[[:[TicketQuery]]]` Macro=====

The [[:trac:TicketQuery|TicketQuery]] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

Example:
<code>
[[:[TicketQuery(version=0.6|0.7&resolution=duplicate)]]]
</code>


This is displayed as:
  [[:[TicketQuery(version=0.6|0.7&resolution=duplicate)]]]

Just like the [[:TracQuery#UsingTracLinks|query: wiki links]], the parameter of this macro expects a query string formatted according to the rules of the simple [[:TracQuery#QueryLanguage|ticket query language]]. This also displays the link and description of a single ticket:
<code>
[[:[TicketQuery(id=123)]]]
</code>


This is displayed as:
  [[:[TicketQuery(id=123)]]]

A more compact representation without the ticket summaries is:
<code>
[[:TicketQuery(version=0.6|0.7&resolution=duplicate,|compact)]]
</code>


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:
<code>
[[:TicketQuery(version=0.6|0.7&resolution=duplicate,|count)]]
</code>


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:
<code>
[[:[TicketQuery(milestone=0.12.8&group=type,format=progress)]]]
</code>


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