How can I pull history from all issues in Jira

Question

I have a project that has been running for 8 months in JIRA. I want to build charts that will show the historical data to determine Cycle Time in every status that is on the board. For resolved and unresolved issues. The company has not installed the plugin that will allow this to be completed.

My goal is to pull all historical data and create a pivot table to determine team progress, constraints and the value that the team has delivered.  How do I extract the data from JIRA?

Thomas Cucolo · Answer

Yeah I requested a list of all project issues from the DB team. Still waiting. I was going to import into Excel and get the information

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Thomas Cucolo

Based on what you want to achieve, the add-on Time in Status for Jira Cloud by SaaSJet maybe an on-point solution for you. With this tool you can easily track the number of times an issue has been in every status. Also, you can get the information about the time in status for each stage in a workflow and the number of times a task has gone from status to status.

Moreover, you can export all necessary data as a report in XLS or CVS file and set up a teamwork schedule to exclude non-working hours or days. Based on this extracted custom report you can proceed with your analysis by building charts etc.

If you want to have a detailed view of how your issues are following the workflow, you can try Issue History. This add-on will display you the history of all changes that had been made by your team in selected issues.

Piotr Bojko · Answer

You can try SmartQL - https://marketplace.atlassian.com/apps/1218767/smart-ql-sql-jql-easy-reporting?hosting=server&tab=overview

With SmartQL you can use SQL, SQL and XPATH to extract data from views exposed by the addon. Then you can export data by csv. You can even connect external tools to the addon/JIRA with jdbc (feature of SmartQL).