Changes between Version 8 and Version 9 of VisualizationPlugin


Ignore:
Timestamp:
Jan 2, 2012 5:24:39 PM (2 years ago)
Author:
robguttman
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • VisualizationPlugin

    v8 v9  
    7070          ELSE e.value END) AS effort 
    7171  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') 
    7475  LEFT OUTER JOIN ticket_custom e ON e.ticket = t.id and e.name = 'effort' 
    7576  WHERE resolution = 'fixed' AND t.type != 'epic'