Available Reports
New Custom Query
Compose a new ticket query by selecting filters and columns to display.
SQL reports and saved custom queries Sort by: Identifier Title
{1} Active Tickets
- List all active tickets by priority.
- Color each row based on priority.
{2} Active Tickets by Version
This report shows how to color results by priority, while grouping results by version.
Last modification time, description and reporter are included as hidden fields for useful RSS export.
{3} Active Tickets by Milestone
This report shows how to color results by priority, while grouping results by milestone.
Last modification time, description and reporter are included as hidden fields for useful RSS export.
{4} Accepted, Active Tickets by Owner
List accepted tickets, group by ticket owner, sorted by priority.
{5} Accepted, Active Tickets by Owner (Full Description)
List tickets accepted, group by ticket owner. This report demonstrates the use of full-row display.
{6} All Tickets By Milestone (Including closed)
A more complex example to show how to make advanced reports.
{7} My Tickets
Tickets that you've accepted, that were assigned to you, or that you've reported.
Hidden feature: /report/7?USER=$name pulls up someone else's ticket list.
{8} Active Tickets, Mine first
- List all active tickets by priority.
- Show all tickets owned by the logged in user in a group first.
{9} Needs Designer
These tickets could use help from someone with design and/or user experience skills.
{10} Good First Bugs
These tickets are good to start with if you're new to contributing. They're not necessarily easy -- although many are -- but they're self-contained, so that you don't need a lot of knowledge of the entire system, historical context, etc in order to make a good patch.
{12} My Patches
Tickets that you've contributed a patch to.
Hidden feature: /report/12?USER=$name pulls up someone else's patch list.
{13} Open Tickets with My Patches
Tickets that you've contributed a patch to, yet the ticket remains open.
Coloured rows are those where the ticket has been marked as needing a patch.
Hidden feature: /report/13?USER=$name pulls up someone else's patch list.
{14} Open Tickets I've Participated In
- Open tickets I've participated in
- Sorted by last modified
Hidden feature: /report/14?USER=$name pulls up someone else's ticket list.
{15} Tickets I've Participated In
- Tickets I've participated in (open and closed)
- Sorted by last modified
Hidden feature: /report/15?USER=$name pulls up someone else's ticket list.
{16} Accessibility
Tickets that describe a11y problems
{17} Latest Tickets
- All tickets opened in the last two months
- Sort by created
- Highlighted tickets are still 'Awaiting Review'
{18} Tickets without a reply (testing)
These tickets are split into four groups:
- Bug reports without any comments at all
- Bug reports without any activity from someone other than the author
- Bug reports without any comments from someone other than the author (thus excluding components and other property changes)
- Enhancements that need a reply
- Tickets that meet any of these criteria, but were themselves opened by a bug gardener
{19} Tickets in the $COMPONENT component
- Active tickets in the $COMPONENT component
- Grouped by workflow and sorted by type, summary
- Accepted tickets have an '*' appended to their owner's name