Hi, I am trying to create a custom report that displays active tickets grouped by milestone, but also displays the description of each milestone underneath the milestone's name. The best I can get is the milestone description being repeated in each ticket row, but I want it just once, and outside of the table of tickets. The "close-but-not- quite" query I have looks like this:
SELECT p.value AS __color__, milestone||' Release' AS __group__, m.description AS _description_, id AS ticket, summary, component, version, t.type AS type, owner, status, time AS created, changetime AS _changetime, reporter AS _reporter FROM ticket t, milestone m LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE status <> 'closed' and t.milestone = m.name ORDER BY (milestone IS NULL),milestone, p.value, t.type, time I have also tried including the description in the __group__ line, but that includes it in the heading and HTML/wiki markup appear to be stripped out/ignored. So is this possible? Any suggestions much appreciated. Cheers, Sam. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
