Skip to main content

Search and Top Navigation

TicketQuery Wiki Macro

The TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.

The query language used by the [[TicketQuery]] macro is described in the [TracQuery#QueryLanguage TracQuery] page.

Usage

[[MacroList(TicketQuery)]]

Examples

||= **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)]] ||

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

||=Number of untriaged tickets (milestone unset): =||\\

|| **[[TicketQuery(status!=closed,milestone=,count)]]**||\\

|| [[TicketQuery(status!=closed,milestone=,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)]] ||

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

#!th rowspan=2, style="text-align: left;"
Details of ticket #1:
#!td style="border-bottom: 0;"

|-

#!td colspan=2, style="border-top: 0;"
[[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 ([[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]) using format=table. You can specify multiple fields and the order they are displayed by placing pipes (col=<field>) between the columns:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

This is displayed as:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

Full rows

In ''table'' format you can specify full rows using |:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]

This is displayed as:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]


See also: TracQuery, TracTickets, TracReports