-- ## 16: Proposals (including closed) ## --

-- Tickets relating to project proposals ordered by time

SELECT id AS ticket, status, milestone, severity, priority, owner,
   time AS created, summary FROM ticket t
WHERE status <> 'closed' and component IN ('Project proposals')
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