Available Reports

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 (not closed)

A more complex example to show how to make advanced reports.

{7} My Tickets

This report lists tickets belonging to the logged-in user (by use of the "$USER" variable).

{8} Active Tickets, Mine first

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

{11} Non-Issues

Issues which are unlikely or impossible to resolve.

{12} Schema Mapping Errors

Things in the schema or data definition which weren't necessarily errors in the Ingres world, but which are errors in the land of PostgreSQL.

{13} Active tickets full description

Full text of all open tickets.

{14} Active tickets full description (capture)

Full text of all open capture tickets.

{15} Active Tickets (copy)

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

{16} Active Tickets (copy)

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

{17} Active tickets full description (capture) by owner

Full text of all open capture tickets by owner.

{18} Active tickets full description (datamodel) by owner (copy)

Full text of all open capture tickets by owner.

{19} All Tickets By Milestone (Sorted by Component, Including closed)

A more complex example to show how to make advanced reports. Probably redundant.

{20} All Tickets By Component (Including closed)

A more complex example to show how to make advanced reports.

{21} UI Faults

Open UI Tickets

{22} Active "Live Service" Tickets by Priority

Specific report for components associated with the live service (post primary project work) that have missing keywords (used for customer assignment).

{23} All "Live Service" Tickets by Component

Specific report for components associated with the live service (post primary project work).

{29} Newest Tickets

Fifty most recently created / updated tickets.

{31} Active "Live Service" Tickets by Priority (with missing keywords)

Specific report for components associated with the live service (post primary project work) that have missing keywords (used for customer assignment).

{32} Duty Allocation

{33} Board of Examiners

{34} HTBN Bids/Allocation

{35} All Active Tickets By Component (No Roadmap Milestone)

A more complex example to show how to make advanced reports.

{36} PG Research Students

{37} Open Tickets with No Milestone

Specific report for tickets that have not yet been allocated to a specific roadmap milestone.

{38} UG/PGT Students

{39} Fixed? Tickets

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

{40} Active "Critical" Tickets

Specific report for all open and critical tickets across all components.

{41} Active Open and Accepted Tickets by Owner

Specific report for open and accepted tickets grouped by owner.

{42} Schema Blockers (Validation Errors)

{43} Active Tickets (by Reporter)

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

{44} All Tickets All Data

All tickets and all data

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