Changes between Version 15 and Version 16 of EpochFieldPlugin

Timestamp:

Feb 6, 2013, 11:21:18 PM (11 years ago)

Author:

matobaa

Comment:

MS SQL Server handles "..." as column_name, '...' as string literal

EpochFieldPlugin

@@ -58 +58 @@
 left join (
     SELECT ticket, author, newvalue AS status, max(time) AS time
-        FROM ticket_change WHERE field = 'status' and status = 'accepted'
-        GROUP BY ticket, newvalue
-) AS a on (a.ticket = ticket.id and a.status = "accepted")
+        FROM ticket_change WHERE field = 'status' and newvalue = 'accepted'
+        GROUP BY ticket, newvalue, author
+) AS a on (a.ticket = ticket.id and a.status = 'accepted')
 left join (
     SELECT ticket, author, newvalue AS status, max(time) AS time
-        FROM ticket_change WHERE field = 'status' and status = 'closed'
-        GROUP BY ticket, newvalue
-) AS c on (c.ticket = ticket.id and c.status = "closed")
+        FROM ticket_change WHERE field = 'status' and newvalue = 'closed'
+        GROUP BY ticket, newvalue, author
+) AS c on (c.ticket = ticket.id and c.status = 'closed')
 }}}
 then the epoch columns (status change time in above example) shows as datetime string. / 更新日時といった列を unixtime ではなく日付文字列で表示します。