William Stein wrote: > On Sat, Sep 12, 2009 at 12:08 PM, Jason Grout > <jason-s...@creativetrax.com> wrote: >> >>> Which features shall we ask the trac and wiki admins to install? >> >> For a long time, I've wanted a report of all tickets on which I've >> participated (i.e., commented, started, been assigned, posted patches, etc.) >> > > trac admins can create arbitrary reports by entering some SQL like this: > > SELECT p.value AS __color__, > (CASE status WHEN 'assigned' THEN 'Assigned' ELSE 'Owned' END) AS > __group__, > id AS ticket, summary, component, version, milestone, > t.type AS type, priority, time AS created, > changetime AS _changetime, description AS _description, > reporter AS _reporter > FROM ticket t, enum p > WHERE t.status <> 'closed' > AND p.name = t.priority AND p.type = 'priority' AND reporter = '$USER' > ORDER BY (status = 'assigned') DESC, p.value, milestone, t.type, time > > maybe I should make you a trac admin so you can do that?
There you go again, spreading the work around :). If you made me trac admin, I'd probably get around to figuring out the database enough to do this eventually, but probably only the next time it bothers me enough to do something about it. Jason -- Jason Grout --~--~---------~--~----~------------~-------~--~----~ To post to this group, send an email to sage-devel@googlegroups.com To unsubscribe from this group, send an email to sage-devel-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sage-devel URLs: http://www.sagemath.org -~----------~----~----~----~------~----~------~--~---
