Changes between Version 6 and Version 7 of EpochFieldPlugin


Ignore:
Timestamp:
Mar 31, 2012 10:34:16 AM (2 years ago)
Author:
matobaa
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • EpochFieldPlugin

    v6 v7  
    2626== Example == 
    2727=== epoch field === #field 
     28trac.ini (or CustomFieldAdminPlugin): 
    2829{{{ 
    2930[ticket-custom] 
     
    3435 
    3536=== epoch report === #report 
     37in trac.ini: 
    3638{{{ 
    3739[epochfield] 
     
    4042time_columns = .*_time, .*時刻 
    4143}}} 
     44report query as: 
     45{{{ 
     46select id, summary, ticket.time, 
     47    a.time as accepted_datetime, 
     48    c.time as closed_datetime, 
     49    c.author as Closer 
     50from ticket 
     51left join ( 
     52    SELECT ticket, author, newvalue AS status, max(time) AS time 
     53        FROM ticket_change WHERE field = 'status' and status = 'accepted' 
     54        GROUP BY ticket, newvalue 
     55) AS a on (a.ticket = ticket.id and a.status = "accepted") 
     56left join ( 
     57    SELECT ticket, author, newvalue AS status, max(time) AS time 
     58        FROM ticket_change WHERE field = 'status' and status = 'closed' 
     59        GROUP BY ticket, newvalue 
     60) AS c on (c.ticket = ticket.id and c.status = "closed") 
     61}}} 
     62[[Image(report.png)]] 
    4263 
    4364== Recent Changes ==