Use this, actually this is one of my most usefull report
SELECT
t.milestone AS __group__,
id AS ticket, summary, status, priority, resolution, version,
t.type AS type, owner,
changetime AS modified,
time AS _reported, reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE EXISTS(SELECT 1 FROM permission where username=$USER and
action='root')
and status<>'closed'
ORDER BY (milestone IS NULL), milestone DESC, priority
Enjoy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of EddieO
Sent: Tuesday, February 03, 2009 6:14 PM
To: Trac Users
Subject: [Trac] looking for SQL for canned report "All Tickets By Milestone
(Including closed)"
I just modified this report and screwed it up, and didn't keep the raw SQL
beforehand. Does anyone have the SQL for this report?
Thanks,
EddieO
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
