Agile Board Custom Reports

Anthony Fontana March 6, 2014

How do you create a report that breaks down the time spent and time remaining for each developer in a given sprint?

1 answer

0 votes
Pablo Beltran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2016

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. 

  1. Get the sprint via the BOARDSSPRINT table
  2. join the BOARDSPRINTISSUES table to get the issues belonging to the Sprint
  3. join the ISSUEWORKLOGS table to get the worklog records for each developer on every issue.

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.

 

Suggest an answer

Log in or Sign up to answer