My Trac has some reports that I would like to update how they are done. As an example, report 1 (Active tickets) is implemented as:
SELECT p.value AS __color__, id AS ticket, summary, milestone, t.type AS type, owner, status, time AS created, changetime AS _changetime, t.description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE status <> 'closed' ORDER BY CAST(p.value AS int), milestone, t.type, time I would like to change report 1 so Active Tickets are selected in the newer way where you can select filters, columns, etc from the GUI. I want to keep the report number the same. So how could I do this change? I am guessing these are defined in the trac database. Is there a how-to on doing this change? I surely do not want to muck up the database! -- Roger Oberholtzer -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/trac-users/CANkOqwNzT1wx9WfeKavOHXhOWAv9%3DoNUev5raR%3DzT_uWAATosQ%40mail.gmail.com.
