Changes between Version 17 and Version 18 of VisualizationPlugin


Ignore:
Timestamp:
Jan 3, 2012 2:03:02 AM (2 years ago)
Author:
robguttman
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • VisualizationPlugin

    v17 v18  
    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' 
     72  JOIN ticket_change tc ON tc.ticket = t.id AND tc.field = 'status' AND tc.newvalue='closed' 
    7373           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') 
    7576  LEFT OUTER JOIN ticket_custom e ON e.ticket = t.id and e.name = 'effort' 
    7677  WHERE resolution = 'fixed' AND t.type != 'epic'