Issue with Exporting Complete Issue History in Jira Cloud for Sheets

Question

Hello Jira Community,

I am currently using the Google Sheets extension "Jira Cloud for Sheets" to import issues, specifically focusing on the data fields "Status Transition.to" and "Status Transition.from". However, I have encountered a limitation where it seems to only read the last 100 entries of the issue history.

In our workflow, since we also utilize GitLab, the issue history can include various entries such as "updated the RemoteIssueLink", which leads to the history exceeding 100 entries. This results in crucial information regarding status transitions being missing in Google Sheets.

Is there a way to export the complete issue history, or any settings I can adjust to ensure all relevant transition data is included in the Google Sheets export?

Thank you for your assistance!

Aron Gombas _Midori_ · Answer

You can export the issue history to a standard XLSX file, then import that to a Google Sheet.

Our Better Excel Exporter app can produce this for you in this format (there is no limit for the history entries!). You can choose the fields to include in the left, then the history entry columns (field name, date, author, old and new value) are added in the right:

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

Petru Simion [Simitech Ltd.] · Answer

Hi @Uwe Pilz ,

You will need to write a script that will call the API function repeteadly untill you extract all values.

If you are open to using apps you can use Issue History Dashboard for Jira an app provided by our company.

You can retreive all values of history for all issues by project, or you can filter by various criteria.

The result is presented in a paginated table and you can export it entirelly in CSV format for further analysis and processing.

Regards,

Petru

Madhu_RVS · Answer

Hi @Uwe Pilz

If you are open to try a mktplace app to export issue history, you may want to have a look at

Issue History Reports

We have built an app to extract changelog data in a simple and easy to use interface with the ability to export all the changes to a csv file.

Disclaimer : i am part of the app team