{1} Active Tickets (495 matches)

• List all active tickets by priority.
• Color each row based on priority.

Orig query:

SELECT p.value AS color,

id AS ticket, summary, component, version, milestone, t.type AS type, owner, status, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter

FROM ticket t, enum p WHERE status <> 'closed'

AND p.name = t.priority AND p.type = 'priority'

ORDER BY p.value, milestone, t.type, time