This page documents the 0.13 release. Documentation for other releases can be found here.

This page was a draft. See default TicketQuery page now.

TicketQuery Wiki Macro

TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

This macro accepts a comma-separated list of keyed parameters, in the form "key=value", and can be used as follows:

[[TicketQuery([key=value][,key=value][,key=value]...)]]

If the key is the name of a ticket field, the value must use the syntax of a filter specifier as defined in TracQuery#QueryLanguage.

• Note that this is not the same as the simplified URL syntax used for query: links starting with a ? character.
• Commas (,) can be included in field values by escaping them with a backslash (\).

The date keys created and modified can also constrain the criteria. Again, see TracQuery#QueryLanguage.

In addition to filters, several other named parameters can be used to control how the results are presented. All of them are optional.

The date keys created and modified can also constrain the criteria. Again, see TracQuery#QueryLanguage.

In addition to filters, several other named parameters can be used to control how the results are presented. All of them are optional.

Key	Description & Details	Default
col	Pipe-separated list of columns and its order to show (requires format=table).	col=id|summary |owner|type| status|priority |milestone
desc	Reverse (true) the natural display order of the tickets.	desc=false
format1	Sets how to display the list of tickets: * list — ticket id next to the summary, each ticket on a separate line. * compact — comma-separated list of ticket ids. * count — the count of matching tickets * table — similar to the custom query view (but without the controls) * progress — a view similar to the milestone progress bars.	format=list
group	Sets the ticket field for grouping tickets.	None
groupdesc	Reverse (true) the natural display order of the groups.	groupdesc=false
max	Sets the limit number of tickets to display (max=0 means no maximum).	max=0
order	Sets the ticket field for ordering tickets.	order=id
rows	Pipe-separated list of ticket fields to be viewed as a row, e.g. rows=description|summary (requires format=table)	None
verbose	Get the description for the listed tickets (true). Use with format=table only. Deprecated (< 0.12) in favor of the rows key.	verbose=false

Note ¹

For compatibility with Trac 0.10, if there's a last positional parameter given to the macro, it will be used to specify the format.

Note

Also, for compatibility with Trac 0.10, using "&" as a field separator still works (except for order) but is deprecated.

Example

• Number of Triage tickets: 22
  • got with [[TicketQuery(status=new&milestone=, count)]]
• Number of new tickets: 1063
  • got with [[TicketQuery(status=new, count)]]
• Number of reopened tickets: 4
  • got with [[TicketQuery(status=reopened, count)]]
• Number of assigned tickets: 22
  • got with [[TicketQuery(status=assigned, count)]]
• Number of invalid tickets: 1514
  • got with [[TicketQuery(status=closed&resolution=invalid, count)]]
• Number of worksforme tickets: 1420
  • got with [[TicketQuery(status=closed&resolution=worksforme, count)]]
• Number of duplicate tickets: 2192
  • got with [[TicketQuery(status=closed&resolution=duplicate, count)]]
• Number of wontfix tickets: 994
  • got with [[TicketQuery(status=closed&resolution=wontfix, count)]]
• Number of fixed tickets: 4589
  • got with [[TicketQuery(status=closed&resolution=fixed, count)]]
• Total number of tickets in Trac is 12394
  • got with [[TicketQuery(status=new|assigned|reopened|closed, count)]]
• The last 5 modified tickets in Trac are: #13804, #13792, #13784, #13774, #13318 and the very last one is detailed below:

  Results (1 of 6)

  1 2 3 4 5 6 →

  Ticket	Resolution	Owner	Reporter
  #13804	fixed	Dirk Stöcker	btbn@…
  Summary	convert_db fails if both spamfilter and tags plugin are enabled

  1 2 3 4 5 6 →
  • got with [[TicketQuery(max=1,modified=lastmonth..thismonth, ,desc=1,format=table,col=resolution|owner|reporter,rows=summary)]]

---

See also: TracQuery, TracTickets, TracReports, TracGuide