Compose a new ticket query by selecting filters and columns to display.
SQL reports and saved custom queries Sort by: Identifier Title
This report shows how to color results by priority, while grouping results by component.
Last modification time, description and reporter are included as hidden fields for useful RSS export.
This report demonstrates the use of the automatically set USER dynamic variable, replaced with the username of the logged in user when executed.
A more complex example to show how to make advanced reports.
List tickets, group by ticket owner, sorted by priority.
- List all active tickets by priority.
- Color each row based on priority.