Changes between Version 15 and Version 16 of EpochFieldPlugin


Ignore:
Timestamp:
Feb 7, 2013, 12:21:18 AM (23 months ago)
Author:
matobaa
Comment:

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

Legend:

Unmodified
Added
Removed
Modified
  • EpochFieldPlugin

    v15 v16  
    5858left join (
    5959    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')
    6363left join (
    6464    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')
    6868}}}
    6969then the epoch columns (status change time in above example) shows as datetime string. / 更新日時といった列を unixtime ではなく日付文字列で表示します。