Available Reports

SQL reports and saved custom queries Sort by: Identifier Title

{44} All Tickets All Data

All tickets and all data

{43} Active Tickets (by Reporter)

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

{42} Schema Blockers (Validation Errors)

{41} Active Open and Accepted Tickets by Owner

Specific report for open and accepted tickets grouped by owner.

{40} Active "Critical" Tickets

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

{39} Fixed? Tickets

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

{38} UG/PGT Students

{37} Open Tickets with No Milestone

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

{36} PG Research Students

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

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

{34} HTBN Bids/Allocation

{33} Board of Examiners

{32} Duty Allocation

{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).

{29} Newest Tickets

Fifty most recently created / updated tickets.

{23} All "Live Service" Tickets by Component

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

{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).

{21} UI Faults

Open UI Tickets

{20} All Tickets By Component (Including closed)

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

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

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

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

Full text of all open capture tickets by owner.

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

Full text of all open capture tickets by owner.

{16} Active Tickets (copy)

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

{15} Active Tickets (copy)

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

{14} Active tickets full description (capture)

Full text of all open capture tickets.

{13} Active tickets full description

Full text of all open tickets.

{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.

{11} Non-Issues

Issues which are unlikely or impossible to resolve.

{8} Active Tickets, Mine first

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

{7} My Tickets

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

{6} All Tickets By Milestone (not closed)

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

{5} Accepted, Active Tickets by Owner (Full Description)

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

{4} Accepted, Active Tickets by Owner

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

{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.

{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.

{1} Active Tickets

  • List all active tickets by priority.
  • Color each row based on priority.
Note: See TracReports for help on using and creating reports.