Available Reports

SQL reports and saved custom queries Sort by: Identifier Title

Accepted, Active Tickets by Owner {4}

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

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

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

Active Tickets by Milestone {3}

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.

Active "Critical" Tickets {40}

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

Active "Live Service" Tickets by Priority {22}

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

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

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

Active Open and Accepted Tickets by Owner {41}

Specific report for open and accepted tickets grouped by owner.

Active Tickets {1}

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

Active Tickets (by Reporter) {43}

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

Active Tickets (copy) {15}

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

Active Tickets (copy) {16}

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

Active Tickets by Version {2}

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.

Active Tickets, Mine first {8}

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

Active tickets full description {13}

Full text of all open tickets.

Active tickets full description (capture) {14}

Full text of all open capture tickets.

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

Full text of all open capture tickets by owner.

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

Full text of all open capture tickets by owner.

All "Live Service" Tickets by Component {23}

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

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

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

All Tickets All Data {44}

All tickets and all data

All Tickets By Component (Including closed) {20}

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

All Tickets By Milestone (not closed) {6}

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

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

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

Board of Examiners {33}

Duty Allocation {32}

Fixed? Tickets {39}

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

HTBN Bids/Allocation {34}

My Tickets {7}

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

Newest Tickets {29}

Fifty most recently created / updated tickets.

Non-Issues {11}

Issues which are unlikely or impossible to resolve.

Open Tickets with No Milestone {37}

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

PG Research Students {36}

Schema Blockers (Validation Errors) {42}

Schema Mapping Errors {12}

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.

UG/PGT Students {38}

UI Faults {21}

Open UI Tickets

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