-- ## 2: Active Tickets by Version ## -- SELECT p.value AS __color__, 'Version: ' || (CASE WHEN version='' THEN 'none' ELSE version END) AS __group__, id AS ticket, summary, component, t.type AS type, owner, status, changetime AS modified, milestone as _milestone, time AS _time, 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 (version='') ASC, version, p.value, (CASE WHEN t.type='defect' THEN 'aaa' WHEN t.type='task' THEN 'aab' WHEN t.type='enhancement' THEN 'aac' ELSE t.type END), changetime DESC