-- ## 6: Active Tickets By Milestone  ## --

-- This report shows how to color results based on priority,
-- group results based on milestone. Last modification time, 
-- description and reporter are included as hidden fields for 
-- a useful RSS export.

SELECT p.value AS __color__,
       t.milestone||' Release' AS __group__,
       t.id AS ticket, t.summary, t.component, t.version, t.type AS type, t.severity, 
       t.owner, t.status,
       t.time AS created,
       t.changetime AS _changetime, t.description AS _description, t.reporter AS _reporter
  FROM ticket t, enum p
  WHERE status <> 'closed' 
    AND p.name = t.priority AND p.type = 'priority'
  ORDER BY (t.milestone IS NULL OR t.milestone=''),t.milestone, p.value, id DESC