-- ## 11: All Tickets by Owner, colour for status ## --

-- 
-- List all tickets, group by ticket owner, sorted by status.



SELECT owner AS __group__,
   p.value as __color__,
   (CASE status 
          WHEN 'closed' THEN 'background: lightgray;' 
          WHEN 'new' THEN 'background: orange;'
          WHEN 'assigned' THEN 'background: yellow;'
          ELSE '' END) AS __style__,id AS ticket,status,  summary,  component AS _component, version, milestone AS _milestone ,  t.type AS type, changetime AS modified, time AS created,   description AS _description,  reporter AS reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  ORDER BY owner, status, CAST(p.value AS int), t.type, time