How Many Hours Have I Spent Doing Reviews?

Over on the feedback forum for our code review tool, James asked for a report that will show the total amount of time he has spent doing reviews. We don't have a report that shows that exact value but we do have a view setup in the database that makes it easy to calculate.

This query (for MySQL, adjustments might be necessary for other databases) will return that value, in hours, for the user greggs:

select

  sum(person_hours) hours_reviewing

from review_activity

where userid = (select user_id from user where user_login = 'greggs');


Close

By submitting this form, you agree to our
Terms of Use and Privacy Policy

Thanks for Subscribing

Keep an eye on your inbox for more great content.

Continue Reading

Add a little SmartBear to your life

Stay on top of your Software game with the latest developer tips, best practices and news, delivered straight to your inbox