Available Reports

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, by Priority

  • List all active tickets by priority.
  • Color each row based on priority.

{2} Active Tickets by Component

{3} Active Tickets

{4} Active Assigned Tickets, by Owner

List assigned tickets, group by ticket owner, sorted by priority.

{5} New Tickets, in the last week

List tickets assigned, group by ticket owner. This report demonstrates the use of full-row display.

{6} My Tickets

{7} Tickets modified in the last 24 Hours

{8} Tickets modified in the last 7 days

  • List all active tickets by priority.
  • Show all tickets owned by the logged in user in a group first.

{9} Active Bugs by Component

{10} Active Feature Requests and Feature Improvements by Component

modified a week ago

{11} Tickets by Milestone

{12} All Tickets

{13} All Tickets by Component

SELECT p.value AS color,

component AS group, id as ticket, summary, t.type AS type, owner, status, milestone time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter

FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' ORDER BY (component IS NULL),component, t.type, t.status, p.value, time DESC

{14} All BW Admin Tickets by Status

{15} All BW Blogs Tickets by Status

{16} All BW Database Tickets by Status

{17} All BW Forum Tickets by Status

{18} All BW Gallery Tickets by Status

{19} Tickets that need testing on alpha

Display all tickets that are set to "testing".

{20} Tickets that need testing on local installs

Displays all tickets that should be tested on local clones of Rox before being deployed on alpha.

{21} Tickets that await deployment on alpha

Displays tickets that have been tested successfully on a local clone and which need to be tested on alpha once fixes are deployed there.

{22} Easy tickets

Open tickets that are tagged "easy" for new members of the development team.

{23} All unassigned milestone tickets

Shows all tickets that aren't assigned to any milestone

{24} Backlog

Lists all tickets that have been reviewed and accepted to be fixed.

{25} Current Milestone

{26} Next Milestone

Shows the content of the next milestone

Note: See TracReports for help on using and creating reports.