I would like to know:
Is there any resource you can point me to that can help me create such sql queries against Crucible database? I am stuck with creating joins with cru_review and cru_user...
I investigated cru_time_spent from cru_review_participant, but I have another thing to think about -
how to interpret the time in cru_time_spent.... values varies from 2 or 3 to 223773 is it presented in miliseconds? It looks like miliseconds, but just wanted to make sure...
Thanks,
Blazej
Community moderators have prevented the ability to post new answers.
The REST call
includes the timeSpent as a field
If you hit that URL with a browser on your instance it should render as an XML document with the fields
Yes, cru_time_spent is milliseconds.
I should note that the Crucible schema is not considered a public interface and is subject to change between versions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Conor, so is there a way to get such data through e.g. REST interface? Or is there a way to propose a new method to REST interface?
I would really need the way to gather review metrics - which for example would consist of review time for each user or time per LOC... with my own filter options.
Best regards,
Blazej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.