-- ## 9: All tickets (compact) ## --

-- All tickets (including closed) in compact format ordered by time

SELECT id AS ticket, status, component, t.type AS type, severity, priority, owner,
   time AS created, summary FROM ticket t
ORDER BY time DESC


--##SELECT id AS ticket, status, t.type AS type, severity, priority, owner, 
--##       time as created, summary FROM ticket 
--##  WHERE status IN ('new', 'assigned', 'reopened', 'closed')
--##  ORDER BY time