-- ## 14: All Tickets by Milestone ## -- -- In each Milestone, ordered by time, type, owner, priority -- -- No system tickets. SELECT p.value AS __color__, 'Milestone '||milestone AS __group__, id AS ticket, summary, component, version, t.type AS type, owner, status, time AS created, changetime AS modified, description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE component <> 'System aspects' ORDER BY milestone,(milestone IS NULL), time, t.type, owner,CAST(p.value AS int)