SQL for JIRA wraps the JIRA Java API as well as the JIRA Software (Agile) REST API under an uniform SQL layer and it is able to make such reports in a breeze.
As it is pure SQL you can aggregate worklogs with the SUM function, use the GROUP BY clause to group by JIRA user and display the results in your favorite reporting tool by using JDBC.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot