= All closed tickets =

{{{
#!SQLTable
SELECT owner, to_date(to_char(to_timestamp(changetime),'MM/DD/YYYY'),'MM/DD/YYYY') as lastchange, scheduled, 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' 
ORDER BY owner, scheduled

}}}