Report time spent by a user over specific time periods

XMLWordPrintable

      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;

              Assignee:
              Unassigned
              Reporter:
              Felipe Kraemer
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: