-- ## 3: Open tickets, changed/created in the last 5 days ## --

-- Active tickets, changed/created in the last 5 days

SELECT p.value AS __color__,
   id AS ticket, summary, component, version, t.type AS type, 
   owner, status,
   time AS created
  FROM ticket t, enum p
  WHERE status <> 'closed' 
AND extract(epoch from now())-changetime/1000000 < 5*86400
AND p.name = t.priority AND p.type = 'priority'
  ORDER BY changetime desc