-- ## 4: Active Tickets by Owner ## -- SELECT p.value AS __color__, owner AS __group__, id AS ticket, summary, component, version, milestone, t.type AS type, status, changetime AS modified, 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 owner, (status='assigned') DESC, 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