If a milestone only contains closed tickets, we assume it is completed and don't need to see it. However, if a milestone contains active tickets, we'd like to see *al*l tickets pertaining to this milestone - including closed (resolved) ones. As a starting point, I'd like to use the following report, slightly customized to our site
<pre> SELECT p.value AS __color__, 'Milestone '||milestone AS __group__, id AS ticket, summary, component, t.type AS type, owner, status, c.value AS estimate, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'estimate') LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE status <> 'closed' ORDER BY milestone DESC, (milestone IS NULL), t.status, CAST(p.value AS int), t.type, time <pre> To top it off, we'd like to order the tickets not by status but by workflow. Our workflow proceeds through status = new, team_reviewed, agreed, assigned, needs_review, reviewed, merged. At this point the ticket gets closed. (Note that closed isn't a status ... but for the purposes of ordering 'closed' tickets should appear last under the relevant milestone.) Any help with this would be much appreciated. Cheers, Darran. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---