Yeah, I tried to write exactly that query and have been running into SQL problems. I'll poke at it a bit more today if there's a boxen admin around to restart postgres if I mess things up. :-) David
On Wed, Mar 21, 2012 at 08:24, William Stein <wst...@gmail.com> wrote: > 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 > -- 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
