Changes between Version 15 and Version 16 of EpochFieldPlugin


Ignore:
Timestamp:
Feb 7, 2013 12:21:18 AM (17 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 ではなく日付文字列で表示します。