Changes between Version 6 and Version 7 of EpochFieldPlugin

Timestamp:

Mar 31, 2012, 8:34:16 AM (12 years ago)

Author:

matobaa

Comment:

--

EpochFieldPlugin

@@ -26 +26 @@
 == Example ==
 === epoch field === #field
+trac.ini (or CustomFieldAdminPlugin):
 {{{
 [ticket-custom]
@@ -34 +35 @@
 
 === epoch report === #report
+in trac.ini:
 {{{
 [epochfield]
@@ -40 +42 @@
 time_columns = .*_time, .*時刻
 }}}
+report query as:
+{{{
+select id, summary, ticket.time,
+    a.time as accepted_datetime,
+    c.time as closed_datetime,
+    c.author as Closer
+from ticket
+left join (
+    SELECT ticket, author, newvalue AS status, max(time) AS time
+        FROM ticket_change WHERE field = 'status' and status = 'accepted'
+        GROUP BY ticket, newvalue
+) AS a on (a.ticket = ticket.id and a.status = "accepted")
+left join (
+    SELECT ticket, author, newvalue AS status, max(time) AS time
+        FROM ticket_change WHERE field = 'status' and status = 'closed'
+        GROUP BY ticket, newvalue
+) AS c on (c.ticket = ticket.id and c.status = "closed")
+}}}
+[[Image(report.png)]]
 
 == Recent Changes ==