Help on Command Line interface

[lordneeko]

We are evaluating this tool for organizational wide deployment.

We have organizational tools which we are required to populate with Peer Review data (for CMMI Level 5).

I want to be able to produce some of that data simply by querying the reviewassistant database, extracting it to XML, and then uploading it to the Org's tools.

Basically I want to be able to extract the data that is available in the reports, but that doesn't seem possible.

Please help with this.

Also, CMMI requires you to track the time spent by each reviewer performing the review, the time it took an author to make corrections, and other metrics like that.

Does Review Assistant capture any of this data? Even if it doesn't capture elapsed time, if I can extract through query Time Stamps of when events happen (Like time stamp when the Reviewer marks the review as "Complete") then I could generate this data myself.

Thanks.

[AlexeyN]

I suggest you to use Review Assistant command line.

For example, you can query every minute for all changed reviews. So, you will have data to start tracking reviews. The command string shluld look like this:

Code: Select all

ra reviews /l=Admin /pw=password /s=http://reviewassistant.local:85/ReviewAssistant ms=1m /verbose

Read here about 'reviews' command.

As an alternative, you may look at the 'LogEntries' table at the Review Assistant database, which stores all review changes. That feature is undocumented, syntax is complicated and I can't guarantee, that syntax will stay invariable at the future.

Please review and vote for the following topics at our Uservoice or create your own:
http://devart.uservoice.com/forums/1453 ... ode-review
http://devart.uservoice.com/forums/1453 ... ews-issues

[lordneeko]

This doesn't really help though. The returned information doesn't even show the comments that are in the database, just the number of comments on a particular review. We need to be able to pull all this information out for audits. There is currently not way to extract all the date about a review to give to QA.

All this data should be available and able to be queried... It's just a MySQL database right?

[AlexeyN]

Now we are working at that feature. We want to do some kind of printable reports that will look like http://1drv.ms/1AaOnJj. Please send to us your thoughts about that feature.

Review Assistant uses SQLite database.

[lordneeko]

That looks great! And is acceptable. I'd still like the ability to query it out of the database in XML like is already available so we can format the date as we want. But I'll gladly take your solution.

Thanks! Time frame?

[AlexeyN]

We plan to release Review Assistant with that feature in next two months.

[lordneeko]

Was this implemented?

[AlexeyN]

Yes, it was implemented. The release was scheduled for the middle of this month.

[lordneeko]

Excellent Thank you,.