-- ## 17: Closed tickets by time (newest first) ## --

-- Closed tickets in compact format ordered by time

SELECT id AS ticket, status, component, t.type AS type, severity, priority, owner,
   time AS created, changetime AS modified, summary FROM ticket t
WHERE status IN ('closed')
ORDER BY modified 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