2 pri.value as __color__,
3 (case when t.nsident is null then t.tid else t.nsident end) as ticket,
5 classification as type,
6 (select mtrack_group_concat(name) from
8 left join components c on (tcm.compid = c.compid)
9 where tcm.tid = t.tid) as component,
10 (select min(duedate) from
12 left join milestones m on (tm.mid = m.mid)
15 and m.duedate is not null
17 (select mtrack_group_concat(name) from
19 left join milestones m on (tm.mid = m.mid)
25 estimated - spent as remaining
28 left join priorities pri on (t.priority = pri.priorityname)
29 left join severities sev on (t.severity = sev.sevname)
34 case when (select count(duedate) from
36 left join milestones m on (tm.mid = m.mid)
37 where tm.tid = t.tid and m.duedate is not null) > 0 then 1 else 0 end,
38 pri.value, sev.ordinal,
45 This report shows tickets assigned to the logged-in user with the highest
46 priority items listed first.
48 This report is run as part of the [wiki:Today] page, and any changes made here
49 will affect that page.