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.

Reply via email to