-- ## 10: Assigned, Active Tickets by Owner (Full Description) ## --

-- List tickets assigned, group by ticket owner
-- This report demonstrates the use of full-row display.

SELECT p.value AS __color__,
       t.owner AS __group__,
       t.id AS ticket, t.summary, t.component, t.milestone, t.type AS type,
       t.severity, t.time AS created,
       t.description AS _description_,
       t.changetime AS _changetime, t.reporter AS _reporter
  FROM ticket t, enum p
  WHERE status = 'assigned'
    AND p.name = t.priority AND p.type = 'priority'
  ORDER BY t.owner, p.value, t.severity, t.time