Changes between Version 6 and Version 7 of EpochFieldPlugin


Ignore:
Timestamp:
Mar 31, 2012, 10:34:16 AM (3 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 ==