Re: developer bug fixing statistics now available

On Sat Dec 16, 2006 at 11:3112AM +0100, Lukas Kahwe Smith wrote: > Martin Jansen wrote: > >On Sat Dec 16, 2006 at 12:0559AM -0800, Justin Patrin wrote: > >>compared to you, of course, and I suspect I won't stay there long. I > >>find it very likely that many people didn't assign bugs to themselves > >>before closing, as I did. > > > >Exactly my thoughts. When I first looked at my bug rank (#68) I was > >pretty surprised, because I have closed much more bugs in the past > >years. But then I realised that those numbers are based on the > >"assigned to" field and suddenly they make much more sense. > > Not sure if this is really practical. We do not log who last changed the > status to a closed state? I don't know much about the bugtracker's DB schema, but the following seems to be what we are looking for: mysql> SELECT COUNT(c.id) AS closed_bugs -> FROM bugdb_comments c, users u, bugdb b -> WHERE b.status = 'Closed' AND b.ts2 = c.ts -> AND c.email = CONCAT(u.handle, '@php.net') -> AND u.handle = 'mj' -> GROUP BY u.handle -> ORDER BY ts DESC; +-------------+ | closed_bugs | +-------------+ | 149 | +-------------+ 1 row in set (1.51 sec) mysql> Greg, can you confirm that this is correct? - Martin