We have been using this, on Trac 0.10.4 running on Windows 2000 Pro.
Title:
Active, Visible Tickets Unchanged for More Than 30 Days, by Time Unchanged
Description:
List tickets that haven't been changed in the last 30 days, sorted by length
of time unchanged.
Only tickets that you have premission to view are shown.
SQL:
SELECT DISTINCT p.value AS __color__,
id AS ticket,
summary, component, milestone, t.type AS type,
owner, reporter, time AS created,
changetime AS modified, description AS _description,
priority,
round(julianday('now') - julianday(changetime, 'unixepoch')) as days
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE ((julianday('now') - julianday(changetime, 'unixepoch')) > 30)
AND status = 'assigned'
ORDER BY changetime, p.value, owner
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.476 / Virus Database: 269.11.4/936 - Release Date: 4/08/2007
14:42
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
