That worked. I wanted the total number of review requests, not the
number of reviews. Perhaps that could be added as a column some day
to the groups page.
On Jan 5, 2:21 pm, Christian Hammond <chip...@chipx86.com> wrote:
> 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
> >> needed.
> > 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
> > list.
> > Chris
> 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
> >>> print
> 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