Crucible : Total review time spent summary report for all the tickets in a project

gurvinderdhillon

Hi,

I am looking out to generate a report in crucible which summarizes the total review time for all the tickets during a month. Basically i want to have a report which shows time spent on indivudual tickets and summation of all the tickets with dates.

Any ideas how we can achieve this. I did google but didnt find anything else and I am new to crucible.

Thanks

Nick

By ticket, do you mean JIRA issue ?

Knowing that each review contains an explicit link to a JIRA issue, you can use the following SQL as the basis Query to select the report you need directly from the Crucible database:

select r.cru_issue_key, sum(cru_time_spent) from cru_review_participant p, cru_review r where p.cru_review_id = r.cru_review_id group by r.cru_issue_key;

If you actually mean: Review when you say 'Ticket', then similarly you can use the following:

select i.cru_proj_key, i.cru_number,  sum(cru_time_spent) from cru_review_participant p, cru_review r, cru_revpermaid i where p.cru_review_id = r.cru_review_id and i.cru_review_id = r.cru_review_id group by i.cru_review_id;