Trevor Parscal wrote:
Can we please exclude branches from this calculation?
I think this is what you want.
mysql> select cr_author, count(*) from code_rev where cr_status = 'fixme'
and cr_path not like '/branches/%' group by cr_author order by count(*)
desc;
+--------------+----------+
| cr_author | count(*) |
+--------------+----------+
| awjrichards | 7 |
| kaldari | 5 |
| nimishg | 5 |
| werdna | 4 |
| platonides | 4 |
| huji | 4 |
| catrope | 3 |
| demon | 3 |
| btongminh | 3 |
| daniel | 2 |
| pdhanda | 2 |
| sean_colombo | 2 |
| happy-melon | 2 |
| tparscal | 2 |
| jeroendedauw | 2 |
| maxsem | 2 |
| mgrabovsky | 1 |
| rainman | 1 |
| yaauie | 1 |
| philip | 1 |
| hartman | 1 |
| ialex | 1 |
| mah | 1 |
| aaron | 1 |
| soxred93 | 1 |
| vyznev | 1 |
| jdpond | 1 |
| leonsp | 1 |
| tisane | 1 |
| thomasv | 1 |
| brion | 1 |
| nikerabbit | 1 |
| siebrand | 1 |
| tstarling | 1 |
| diana | 1 |
| dantman | 1 |
| purodha | 1 |
| svip | 1 |
+--------------+----------+
38 rows in set (0.07 sec)
The total is 74.
This chart could be made dynamic in a Toolserver tool, if there were
interest. It could also possibly go into the extension, but the database
would need some indices first.
MZMcBride