Shawn,
The command line doesn't have a way to do general queries such as this, although you can create custom SQL queries for your Code Collaborator database. Refer to our schema here for specifics:
http://codecollaborator.smartbear.com/docs/manual/6.0/database_schema.htmlIf you have questions about creating a query, email support@codecollab.com. One thing to consider is a query of all completed reviews could (eventually) make for a slow check-in.
What I think would work for what you want to do, and a generally good approach to verifying commits, is to require the author put the review number in the commit comment. This allows you to use the 'ccollab admin review-xml' command line command to dump all the review metadata for a known review number. Your check-in policy could have a review number matching expression to find the review in the commit comment, and then you query the review-xml output for the details you're interested in checking.
Eric
