This looks great -- for ages I've been ignoring the built-in trac reports and using Custom Query because the built-in reports were no use, but these look much more sensible.
One request: can we have a query for "Tickets I authored (including closed)", and similarly "Tickets reviewed by me"? (For me "All my tickets (including closed)" brings up over 500 tickets, but the vast majority of those are ones where I just made one trivial comment or metadata correction, so it would be nice to have a list of only ones where I was an actual author.) David On Wednesday, 21 March 2012 03:29:58 UTC, David Roe wrote: > > Hi everyone, > I've reorganized our trac reports, added a bunch of new ones and changed > the View Tickets button so that it points to > http://trac.sagemath.org/sage_trac/wiki/TicketReports. If you have any > ideas for new reports you can either add them (if you can express them as a > trac query) or reply here (if they need database access). > > There are a couple more queries I'd like to add, but that are currently > too slow with the database setup (and my limited SQL skills). If anyone > has any suggestions for the following I'd like to hear them. > > * A report listing tickets containing an attachment, sorted so that the > authors who have contributed the fewest times appear first. New > contributors often don't know many other developers and can get discouraged > when nobody looks at their contribution. The following SQL query is a > start, but it's already really slow (more than a minute). I don't know if > the problem is the 50000 spam accounts in the session table or something > else. > SELECT sid, > (SELECT COUNT(*) FROM ticket_change WHERE field='comment' AND > author=sid) as changes > FROM session > WHERE authenticated = 1 > ORDER BY changes > > David > -- 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 URL: http://www.sagemath.org
