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.
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs