id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 4296,"Add report to Trac site to show ""Active tickets by last modified date""",sid,Matthew Good,"When doing [wiki:TracTicketTriage ticket triage], I often run across tickets that have been forgotten. But I have to dig to find them. It would be really nice to have a report I could use to show ''most'' and ''least'' active tickets. This report (grabbed from #3393) should do the trick, although it might need a little tweaking for whatever DB t.e.o. is using: {{{ SELECT p.value AS __color__, id AS ticket, summary, component, version, milestone, t.severity AS severity, (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner, (CASE WHEN strftime('%s','now') - changetime > 86400 THEN round((strftime('%s','now') - changetime)/86400,0) || ' days' WHEN strftime('%s','now') - changetime > 3600 THEN round((strftime('%s','now') - changetime)/3600,0) || ' hours' ELSE (strftime('%s','now') - changetime)/60 || ' mins' END) AS Modified, author as Modified_By, description AS _description, reporter AS _reporter FROM ticket t, enum p, (SELECT ticket, author, MAX(time) FROM ticket_change WHERE field = 'comment' GROUP BY ticket) tc WHERE status IN ('new', 'assigned', 'reopened') AND p.name = t.priority AND p.type = 'priority' AND t.id = tc.ticket ORDER BY changetime desc, p.value, milestone, t.severity, time }}} This will display '''active tickets by last modified date'''. Can you add it to t.e.o. reports?",task,closed,normal,,report system,0.10.3,normal,fixed,needinfo,,,,,