-- ## 5: Accepted, Active Tickets by Owner (Full Description) ## --

-- List tickets accepted, 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.time AS created, t.description AS _description_,
   t.changetime AS _changetime, t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status = 'accepted'
  ORDER BY t.owner, CAST(p.value AS int), t.type, t.time