Changes between Version 18 and Version 19 of EpochFieldPlugin


Ignore:
Timestamp:
Apr 9, 2015, 12:08:28 PM (9 years ago)
Author:
figaro
Comment:

Cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • EpochFieldPlugin

    v18 v19  
    2323[[TicketQuery(component=EpochFieldPlugin,group=type,format=progress)]]
    2424
    25 == Get A Plugin or Source
     25== Download
    2626
    2727Download the zipped source from [download:epochfieldplugin here].[[BR]]
     28
     29== Source
     30
    2831You can check out EpochFieldPlugin from [http://trac-hacks.org/svn/epochfieldplugin here] using Subversion, or [source:epochfieldplugin browse the source] with Trac.[[BR]]
    2932入手は[download:epochfieldplugin zip], [http://trac-hacks.org/svn/epochfieldplugin Subversion], [source:epochfieldplugin Trac]でどうぞ。
     
    4750=== Epoch report === #report
    4851
    49 In trac.ini specify field-names you want to translate from epoch to datetime-string in regular-expressions as follows: / trac.ini で 日時表記したいカラム名を正規表現で指定して:
     52In the `trac.ini` file specify the field-names you want to translate from epoch to datetime-string in regular-expressions as follows: / trac.ini で 日時表記したいカラム名を正規表現で指定して:
    5053{{{
    5154#!ini
     
    5962{{{
    6063#!sql
    61 select id, summary, ticket.time,
     64SELECT id, summary, ticket.time,
    6265    a.time as accepted_datetime,
    6366    c.time as closed_datetime,
    6467    c.author as Closer
    65 from ticket
     68FROM ticket
     69LEFT JOIN (
     70    SELECT ticket, author, newvalue AS status, MAX(time) AS time
     71        FROM ticket_change
     72        WHERE field = 'status' AND newvalue = 'accepted'
     73        GROUP BY ticket, newvalue, author
     74) AS a ON (a.ticket = ticket.id AND a.status = 'accepted')
    6675left join (
    67     SELECT ticket, author, newvalue AS status, max(time) AS time
    68         FROM ticket_change WHERE field = 'status' and newvalue = 'accepted'
     76    SELECT ticket, author, newvalue AS status, MAX(time) AS time
     77        FROM ticket_change
     78        WHERE field = 'status' AND newvalue = 'closed'
    6979        GROUP BY ticket, newvalue, author
    70 ) AS a on (a.ticket = ticket.id and a.status = 'accepted')
    71 left join (
    72     SELECT ticket, author, newvalue AS status, max(time) AS time
    73         FROM ticket_change WHERE field = 'status' and newvalue = 'closed'
    74         GROUP BY ticket, newvalue, author
    75 ) AS c on (c.ticket = ticket.id and c.status = 'closed')
     80) AS c ON (c.ticket = ticket.id AND c.status = 'closed')
    7681}}}
    7782