On Tue, Jan 5, 2010 at 10:04 AM, Chris Clark <chris.cl...@ingres.com> wrote:
> grimbeaver wrote:
>> I need a simple way to get the total number of reviews in a group.
>> We've assigned all the code reviews into groups based on project.
>> Project management has to report the total number of code reviews
>> completed for a project to our partner. When you look at the group
>> view it only gives you a count of the pending reviews, no total
>> count. Obviously in an ideal world there will be better reports some
>> day, but for now I just need an easy way to get this number when
> Off the top of my head there are 2 options:
> 1. use the Django manage shell and write simple Python queries
> 2. access the database directly, e.g. using native sql terminal
> monitor tools and query the table(s) directly
> I don't have queries for these but it probably wouldn't take long by poking
> around. The Django tutorials are pretty good if you want to try option #1
> which requires basic Python skills. Option #2 requires basic SQL skills.
> If you create useful scripts they would be good to post back to the mailing
Yeah, these options are necessary for now.
Is it the total number of reviews, or review requests?
To get into the Python shell for Review Board, run:
$ rb-site manage /path/to/site shell
>>> from django.db.models import Count
>>> from reviewboard.reviews.models import ReviewRequest
>>> # Total number of public review requests to a group (pending and
>>> review_requests = ReviewRequest.objects.to_group("yourgroupname",
>>> print review_requests.count()
>>> # Total number of public reviews to all review requests in a group
I think that should work off-hand. Let me know if there are problems with
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com
Want to help the Review Board project? Donate today at
Happy user? Let us know at http://www.reviewboard.org/users/
To unsubscribe from this group, send email to
For more options, visit this group at