Changes between Version 17 and Version 18 of VisualizationPlugin
- Timestamp:
- Jan 3, 2012, 1:03:02 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
VisualizationPlugin
v17 v18 70 70 ELSE e.value END) AS effort 71 71 FROM ticket t 72 72 JOIN ticket_change tc ON tc.ticket = t.id AND tc.field = 'status' AND tc.newvalue='closed' 73 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 WHERE tc2.ticket = t.id AND tc2.field = 'status' 75 AND tc2.newvalue='closed') 75 76 LEFT OUTER JOIN ticket_custom e ON e.ticket = t.id and e.name = 'effort' 76 77 WHERE resolution = 'fixed' AND t.type != 'epic'