-- ## 11: v1.0.1 Final Tickets ## --

-- This report shows tickets for v1.0.1 Final that have been accepted by the ACCORD5 staff.

SELECT p.value AS __color__,
   (CASE status 
      WHEN 'closed' THEN 'color: #777; background: #eaeaea; border-color: #ccc;'
    END) AS __style__,
   id AS ticket, summary, component, status, 
   resolution, version, t.type AS type, priority, time AS created
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE milestone = '1.0.1 Final' AND owner != '' AND status IN ('assigned', 'closed', 'reopened')
  ORDER BY status, p.value, time