I have been banging on this report trying to get it to get it to order
by milestone due date.  Any help would be appreciated!

SELECT p.value AS __color__,
   milestone||' Release' AS __group__,
   id AS ticket, summary, priority, owner, component, reporter, t.type
AS type,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter

  FROM ticket t, enum p
  WHERE status <> 'closed' AND milestone <> ''AND p.name = t.priority
AND p.type = 'priority'
  ORDER BYmilestone, p.value, severity, time

-- 
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.

Reply via email to