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:
where userid = (select user_id from user where user_login = 'greggs');