-- ## 14: Open Tickets only ## --

-- List of open '''bug reports''', '''requested features''' and '''development tickets'''.
-- 
-- For further chronological descriptions see also the '''[http://www.mindstorms.rwth-aachen.de/trac/roadmap Roadmap Schedule]'''.

SELECT 
   t.type AS __group__,
   (CASE status 
      WHEN 'closed' THEN
        'color: black; background: #ddd; border-color: #ccc;'
      ELSE
        (CASE milestone
           WHEN 'vNo' THEN
             'color: #777070;'
           ELSE
             (CASE t.type
                WHEN 'bug report' THEN
                  (CASE priority
                     WHEN 'high' THEN
                       'color: red; font-weight: bold; background: #fdd;'
                     WHEN 'low'  THEN
                        'color: red; font-weight: bold; background: #ffc;'
                     ELSE
                       'color: red; font-weight: bold;'
                   END)
                ELSE
                  (CASE priority
                     WHEN 'high' THEN
                       'background: #fdd;'
                     WHEN 'low'  THEN
                       'background: #ffc;'
                     ELSE
                       'color: black;'         
                   END)
             END)
        END)
    END) AS __style__,

   id AS ticket, summary, priority, component, status, reporter, milestone, owner, changetime AS modified
  FROM ticket t
  WHERE status <> 'closed' 
  ORDER BY t.type ASC, priority ASC, component ASC, id DESC