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 trac-users+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/trac-users/CANkOqwNzT1wx9WfeKavOHXhOWAv9%3DoNUev5raR%3DzT_uWAATosQ%40mail.gmail.com.