TicketQuery
TicketQuery Wiki Macro¶
The TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.
The query language used by the \\ macro is described in the TracQuery page.
Usage¶
Examples¶
| \\Example\\ | \\Result\\ | \\Macro\\ |
|---|
|-----------------------------------------------------------
| Number of Triage tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of new tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of reopened tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of assigned tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of invalid tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of worksforme tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of duplicate tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of wontfix tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of fixed tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of untriaged tickets (milestone unset): | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Total number of tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of tickets reported \\or\\ owned by current user: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of tickets created this month: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of closed Firefox tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of closed Opera tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of closed tickets affecting Firefox and Opera: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of closed tickets affecting Firefox or Opera: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of tickets that affect Firefox or are closed and affect Opera: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Number of closed Firefox tickets that don't affect Opera: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
| Last 3 modified tickets: | \ |
|---|---|
| \\\\ | \ |
\\ |
|-----------------------------------------------------------
Details of ticket #1:`[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]`|-
[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]|-----------------------------------------------------------
Format: list¶
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]This is displayed as:
[[TicketQuery(version=0.6|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:
[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
Format: count¶
[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]This is displayed as:
[[TicketQuery(version=0.6|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:
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:
See also: TracQuery, TracTickets, TracReports