Add report to Trac site to show "Active tickets by last modified date"
|Reported by:||sid||Owned by:||mgood|
When doing 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?
Change History (10)
comment:6 follow-up: ↓ 7 Changed 7 years ago by
- Resolution fixed deleted
- Status changed from closed to reopened
- Version changed from 0.10.2 to 0.10.3