Details
-
Suggestion
-
Resolution: Unresolved
Description
Nowadays it is necessary to access each review a user is a participant of in order to sum the time spent on each review.
It would be great to have a report that would show the total amount of time spent by each user, or by a specific user, over specific time periods.
This query might help:
SELECT i.cru_proj_key, i.cru_number, u.cru_user_name, SUM(p.cru_time_spent) AS time_spent FROM cru_review_participant p, cru_user u, cru_review r, cru_revpermaid i WHERE p.cru_user = u.cru_user_id AND p.cru_review_id = r.cru_review_id AND i.cru_review_id = r.cru_review_id GROUP BY i.cru_proj_key, i.cru_number, u.cru_user_name;