{17} Active Tickets by Component

This report shows how to color results by priority, while grouping results by components.

Last modification time, description and reporter are included as hidden fields for useful RSS export.

Report execution failed: 
AmbiguousColumn: column reference "description" is ambiguous
LINE 8:    changetime AS _changetime, description AS _description,
                                      ^

SELECT COUNT(*) FROM (

SELECT p.value AS __color__,
   'Component: '||component AS __group__,
   id AS ticket, summary, milestone, version, t.type AS type, 
   owner, status,
   time AS created, t.priority,
   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'
  WHERE status <> 'closed' 
  ORDER BY (component IS NULL),component, CAST(p.value AS int), milestone,  t.type, time

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