Changes between Version 15 and Version 16 of EpochFieldPlugin
- Timestamp:
- Feb 6, 2013, 11:21:18 PM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EpochFieldPlugin
v15 v16 58 58 left join ( 59 59 SELECT ticket, author, newvalue AS status, max(time) AS time 60 FROM ticket_change WHERE field = 'status' and status= 'accepted'61 GROUP BY ticket, newvalue 62 ) AS a on (a.ticket = ticket.id and a.status = "accepted")60 FROM ticket_change WHERE field = 'status' and newvalue = 'accepted' 61 GROUP BY ticket, newvalue, author 62 ) AS a on (a.ticket = ticket.id and a.status = 'accepted') 63 63 left join ( 64 64 SELECT ticket, author, newvalue AS status, max(time) AS time 65 FROM ticket_change WHERE field = 'status' and status= 'closed'66 GROUP BY ticket, newvalue 67 ) AS c on (c.ticket = ticket.id and c.status = "closed")65 FROM ticket_change WHERE field = 'status' and newvalue = 'closed' 66 GROUP BY ticket, newvalue, author 67 ) AS c on (c.ticket = ticket.id and c.status = 'closed') 68 68 }}} 69 69 then the epoch columns (status change time in above example) shows as datetime string. / 更新日時といった列を unixtime ではなく日付文字列で表示します。