-- ## 2: Current Defects ## --

--  * All active defects by severity and owner
--  * Color each row based on severity.
--  * If a ticket has been accepted, a '*' is appended after the owner's name

SELECT p.value AS __color__,
   id AS ticket, summary, 
   t.severity, 
   owner, status,
   component,
   time AS created,
--   version,
--   tc.value AS "Due",
--   tt.value AS "Completion Status",
   -- Hidden fields
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
--      ticket_custom tc ON t.id = tc.ticket,
--      ticket_custom tt ON t.id = tt.ticket
  WHERE t.type = 'defect' AND status <> 'closed'      
--     AND tc.name="due_date" 
--     AND tt.name="completion_status"
  ORDER BY p.value, owner