ticketquery

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.

\*\*Example\*\* \*\*Result\*\* \*\*Macro\*\*
Number of \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)]]]

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:

[[:[TicketQuery(version=0.6|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:

[[: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

  • ticketquery.txt
  • Last modified: 2020/07/17 18:33
  • (external edit)