On Wed, Mar 21, 2012 at 4:38 AM, David Loeffler <dave.loeff...@gmail.com> wrote: > 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.)
Is there a report that lists "tickets needing work that I *attached a patch to*"? -- William > > 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 -- William Stein Professor of Mathematics University of Washington http://wstein.org -- 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