2 pri.value AS __color__,
3 (case when t.nsident is null then t.tid else t.nsident end) as ticket,
5 (select mtrack_group_concat(name) from
7 left join components c on (tcm.compid = c.compid)
8 where tcm.tid = t.tid) as component,
9 (select mtrack_group_concat(name) from
11 left join milestones m on (tm.mid = m.mid)
15 classification as type,
17 creat.changedate as created
20 left join priorities pri on (t.priority = pri.priorityname)
21 left join severities sev on (t.severity = sev.sevname)
22 left join changes creat on (t.created = creat.cid)
24 t.status in ('new', 'assigned', 'reopened')
26 pri.value, sev.ordinal,
32 * List all active tickets by priority.
33 * Color each row based on priority.