-- ## 9: Assigned, Active Tickets by Owner ## --

-- List assigned tickets, group by ticket owner, sorted by priority

SELECT p.value AS __color__,
       t.owner AS __group__,
       CASE WHEN summary like '%[%]' THEN 'background: #cfc; color: #090' ELSE '' END AS __style__,
       t.id AS ticket, t.summary, t.component, t.milestone, t.type AS type,
       t.severity, t.time AS created, t.changetime AS _changetime, 
       t.description AS _description, t.reporter AS _reporter
  FROM ticket t,enum p
  WHERE t.status = 'assigned'
    AND p.name=t.priority AND p.type='priority'
  ORDER BY t.owner, (t.summary LIKE '%[%]'), p.value, t.severity, t.time