-- ## 14: Active tickets by time (newest first) ## --

-- Active tickets (including reopened) 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
WHERE status <> 'closed'
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