Changes between Version 17 and Version 18 of VisualizationPlugin

Timestamp:

Jan 3, 2012, 1:03:02 AM (12 years ago)

Author:

Rob Guttman

Comment:

--

VisualizationPlugin

@@ -70 +70 @@
           ELSE e.value END) AS effort
   FROM ticket t
-    JOIN ticket_change tc ON tc.ticket = t.id AND tc.field = 'status' AND tc.newvalue='closed'
+  JOIN ticket_change tc ON tc.ticket = t.id AND tc.field = 'status' AND tc.newvalue='closed'
            AND tc.time=(SELECT max(time) FROM ticket_change tc2
-                                 WHERE tc2.ticket = t.id AND tc2.field = 'status' AND tc2.newvalue='closed')
+                                 WHERE tc2.ticket = t.id AND tc2.field = 'status'
+                                     AND tc2.newvalue='closed')
   LEFT OUTER JOIN ticket_custom e ON e.ticket = t.id and e.name = 'effort'
   WHERE resolution = 'fixed' AND t.type != 'epic'