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

  • List all active tickets by priority.
  • Color each row based on 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.

{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

This report demonstrates the use of the automatically set USER dynamic variable, replaced with the username of the logged in user when executed.

{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} milestone listing

{10} current work by site (including cc)

This report shows current work (i.e. priority major) by site, where a ticket is associated to a site if the reporter, owner, or cc has people from that site.

Note This report has a manually-curated correspondence between sites, trac users, and email addresses.

hmm... I suppose trac lets us pick our own priority names, so I could rename minor to not-started and major to current.

{11} current work by site (owner only)

This report shows current work (i.e. priority major) by site, where a ticket is associated to a site if the owner is from that site.

See also: all-sites tickets

Note This report has a manually-curated correspondence between sites, trac users, and email addresses.

{12} Recent ticket comments

SELECT p.value AS color,

date(detail.time / 1000000, 'unixepoch', 'localtime') AS group, id AS ticket, component, t.summary, detail.time AS date, detail.newvalue comment, t.type AS type, priority, t.time AS created

FROM ticket t

join ticket_change as detail

on detail.ticket = t.id and detail.field in ('comment', 'status')

LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'

AND

datetime(detail.time / 1000000, 'unixepoch', 'localtime')

datetime('now', '-90 day')

{13} Recent ticket comments

{14} My Ticket Work

Shows comments and status changes of the logged in user for the last 90 days.

{15} MU Tickets

{19} UIowa open tickets

{20} milestone progress

excluding minor priority tickets

{21} MCW Tickets

{22} MCW Tickets

{23} MCW All Tickets

{24} Medical College of Wisconsin Tickets

{25} My Tickets (all)

This report demonstrates the use of the automatically set USER dynamic variable, replaced with the username of the logged in user when executed.

{26} Dan's recent ticket comments

{27} RCR - All sites tickets

Tickets for activities that involve all RCR sites, vs. those that are completed centrally / by one site.

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