Changes between Version 8 and Version 9 of VisualizationPlugin


Ignore:
Timestamp:
Jan 2, 2012, 5:24:39 PM (3 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'