-
Notifications
You must be signed in to change notification settings - Fork 0
TicketQuery
trac edited this page Jun 11, 2019
·
1 revision
= 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#QueryLanguage 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)]] |
||
| ----------------------------------------------------------- | ||
| =Number of closed Firefox tickets: = | \ | |
| --- | --- | |
| TicketQuery(status=closed,keywords~=firefox,count) | \ | |
[[TicketQuery(status=closed,keywords~=firefox,count)]] |
||
| ----------------------------------------------------------- | ||
| =Number of closed Opera tickets: = | \ | |
| --- | --- | |
| TicketQuery(status=closed,keywords~=opera,count) | \ | |
[[TicketQuery(status=closed,keywords~=opera,count)]] |
||
| ----------------------------------------------------------- | ||
| =Number of closed tickets affecting Firefox and Opera: = | \ | |
| --- | --- | |
| TicketQuery(status=closed,keywords~=firefox opera,count) | \ | |
[[TicketQuery(status=closed,keywords~=firefox opera,count)]] |
||
| ----------------------------------------------------------- | ||
| =Number of closed tickets affecting Firefox or Opera: = | \ | |
| --- | --- | |
| **[[TicketQuery(status=closed,keywords~=firefox | opera,count)]]** | \ |
| `[[TicketQuery(status=closed,keywords~=firefox | opera,count)]]` | |
| ----------------------------------------------------------- | ||
| =Number of tickets that affect Firefox or are closed and affect Opera: = | \ | |
| --- | --- | |
| TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count) | \ | |
[[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]] |
||
| ----------------------------------------------------------- | ||
| =Number of closed Firefox tickets that don't affect Opera: = | \ | |
| --- | --- | |
| TicketQuery(status=closed,keywords~=firefox - opera,count) | \ | |
[[TicketQuery(status=closed,keywords~=firefox -opera,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:
]}
```td
`[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]`
|-
[[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
This is displayed as:
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
Just like the [query: wiki links](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracQuery#using-trac-links), the parameter of this macro expects a query string formatted according to the rules of the simple [ticket query language](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracQuery#query-language). This also displays the link and description of a single ticket:
This is displayed as:
[[TicketQuery(id=123)]]
A more compact representation without the ticket summaries is:
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:
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](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracQuery), [TracTickets](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracTickets), [TracReports](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracReports), [TracGuide](https://github.com/CABLE-LSM/CABLE-Trac-archive/wiki/TracGuide)