Noah Kantrowitz wrote: > SQL is not hierarchical, you need to JOIN against the milestone table.
Thanks. I now have: SELECT p.value AS __color__, milestone||' Release' AS __group__, id AS ticket, summary, component, version, t.type AS type, owner, status, time AS created, changetime AS _changetime, t.description AS _description, reporter AS _reporter FROM ticket t, enum p JOIN milestone ON milestone.name=t.milestone WHERE status <> 'closed' AND p.name = t.priority AND p.type = 'priority' ORDER BY (milestone IS NULL),milestone.Due, p.value, t.type, time But I have two issues: 1) I want to show the milestone due date. (Ideally in the group header like "FooBar Release (9/24/2008)".) 2) I want to put milestones with null due dates at the bottom. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
