-- ## 2: Active Tickets by Component ## -- -- -- This report shows how to color results by priority, -- while grouping results by component. -- -- Last modification time, description and reporter are included as hidden fields -- for useful RSS export. SELECT p.value AS __color__, component AS __group__, id AS ticket, summary, t.type AS type, owner, status, time AS created, changetime AS _changetime, description AS _description, c.value AS due_date, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' LEFT JOIN ticket_custom c ON t.id = c.ticket AND c.name = 'due_date' WHERE status <> 'closed' ORDER BY component, p.value, t.type, time