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?

William

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to