svn commit: r1507159 - /bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py

[hu...@apache.org]

Author: huaxiang
Date: Fri Jul 26 00:12:57 2013
New Revision: 1507159

URL: http://svn.apache.org/r1507159
Log:
Ticket #605 [BEP-0008]#2 Display historical status changes for all ticket order by ticket id - SQL statements for new report added into db_default.py

Modified:
    bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py

Modified: bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py
URL: http://svn.apache.org/viewvc/bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py?rev=1507159&r1=1507158&r2=1507159&view=diff
==============================================================================
--- bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py (original)
+++ bloodhound/branches/bep_0008_time_series_reports/trac/trac/db_default.py Fri Jul 26 00:12:57 2013
@@ -351,7 +351,22 @@ SELECT p.value AS __color__,
   WHERE status <> 'closed'
   ORDER BY (COALESCE(owner, '') = $USER) DESC, """
   + db.cast('p.value', 'int') + """, milestone, t.type, time
-"""))
+"""),
+#----------------------------------------------------------------------------
+('Historical status changes - All tickets',
+"""\
+Display historical status changes for all ticket order by ticket id.
+""",
+"""\
+SELECT p.value AS __color__,
+    t.id AS ticket, t.type AS type, t.time AS created, priority,
+    owner, status, reporter, milestone, summary, tc.time AS tctime,
+    tc.oldvalue AS Previous_status, tc.newvalue AS Current_status
+  FROM ticket t, ticket_change tc
+  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
+  WHERE t.id=tc.ticket AND field='status'
+  ORDER BY id,
+""" % db.cast('p.value', 'int') ))
 
 
 ##