---
layout: wiki
title: TicketQuery
updated: 2021-04-16 08:14
author: trac
default: true
---

## TicketQuery Wiki Macro

The TicketQuery macro lets you display ticket information anywhere that accepts [WikiFormatting](/briareus/notes/WikiFormatting/).
The query language used by the \`\` macro is described in the TracQuery page.

### Usage

### Examples

| \*\*Example\*\* | \*\*Result\*\* | \*\*Macro\*\* |
|---|---|---|

\|-----------------------------------------------------------

<table>
<tr><TH>Number of Triage tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of new tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of reopened tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of assigned tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of invalid tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of worksforme tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of duplicate tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of wontfix tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of fixed tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of untriaged tickets (milestone unset):</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Total number of tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of tickets reported \*\*or\*\* owned by current user:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of tickets created this month:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of closed Firefox tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of closed Opera tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of closed tickets affecting Firefox and Opera:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of closed tickets affecting Firefox or Opera:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of tickets that affect Firefox or are closed and affect Opera:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Number of closed Firefox tickets that don't affect Opera:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

<table>
<tr><TH>Last 3 modified tickets:</TH><td>\\</td></tr>
<tr><td>\*\*\*\*</td><td>\\</td></tr>
<tr><td>\`\`</td></tr>
</table>

\|-----------------------------------------------------------

```th
Details of ticket #1:
```

```td
```

```td
`[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]`
```

\|-

```td
[[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](/briareus/notes/TracQuery/), [TracTickets](/briareus/notes/TracTickets/), [TracReports](/briareus/notes/TracReports/)