Changes between Version 8 and Version 9 of VisualizationPlugin
- Timestamp:
- Jan 2, 2012, 4:24:39 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
VisualizationPlugin
v8 v9 70 70 ELSE e.value END) AS effort 71 71 FROM ticket t 72 JOIN ticket_change tc ON tc.ticket = t.id and tc.field = 'status' and tc.newvalue='closed' 73 and tc.time=(SELECT max(time) from ticket_change tc2 where tc2.ticket = t.id and tc2.field = 'status' and tc2.newvalue='closed') 72 JOIN ticket_change tc ON tc.ticket = t.id AND tc.field = 'status' AND tc.newvalue='closed' 73 AND tc.time=(SELECT max(time) FROM ticket_change tc2 74 WHERE tc2.ticket = t.id AND tc2.field = 'status' AND tc2.newvalue='closed') 74 75 LEFT OUTER JOIN ticket_custom e ON e.ticket = t.id and e.name = 'effort' 75 76 WHERE resolution = 'fixed' AND t.type != 'epic'