-- ## 7: My Tickets ## --

SELECT p.value AS __color__,
   (CASE status WHEN 'assigned' THEN 'Assigned' ELSE 'Owned' END) AS __group__,
   id AS ticket, summary, component, version, milestone,
   t.type AS type, priority, changetime AS modified,
   time AS _time, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed' AND owner = $USER
  ORDER BY (status = 'assigned') DESC, p.value, (milestone = '') ASC,
  (CASE
     WHEN t.type='defect' THEN 'aaa'
     WHEN t.type='task' THEN 'aab'
     WHEN t.type='enhancement' THEN 'aac'
     ELSE t.type
   END), changetime DESC