Changes between Initial Version and Version 1 of RecentlyClosedTickets

Timestamp:

2010-10-01T23:19:13+02:00 (14 years ago)

Author:

trac

Comment:

--

RecentlyClosedTickets

@@ +1 @@
+= Recently closed tickets =
+
+{{{
+#!SQLTable
+SELECT owner, to_date(to_char(to_timestamp(changetime),'MM-DD-YYYY'),'MM-DD-YYYY') as lastchange, scheduled, resolution, component, t.type AS type, project || ':#' || id AS ticket, summary 
+FROM multitrac_query('status = ''closed'' AND owner <> ''''') t 
+LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' 
+WHERE to_date(to_char(to_timestamp(changetime),'MM-DD-YYYY'),'MM-DD-YYYY') > current_date - 14 ORDER BY lastchange DESC, owner, scheduled
+
+}}}