Trac Reports

Useful Progress Report
The following report highlights your accepted tickets as green, and shows closed tickets in a grey colour: SELECT p.value AS __color__, id AS ticket, summary, component, t.type AS type, priority, (CASE status      WHEN 'assigned' THEN  'background: #0f0'            WHEN 'closed' THEN  'color: #ddd;background: #fff;border-color: #fff'      ELSE         (CASE owner WHEN $USER THEN 'font-weight: bold' END)    END) AS __style__, 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 t.milestone = 'third_playable' AND t.owner = $USER ORDER BY   CASE status WHEN 'accepted' THEN 1 WHEN 'new' THEN 2 WHEN 'closed' THEN 3 WHEN 'reopened' THEN 4 ELSE NULL END, p.value, t.type, time