Issue with Exporting Complete Issue History in Jira Cloud for Sheets

[Uwe Pilz]

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!

[ELFAPP Technologies]

Hey @Uwe Pilz 

Not sure if there are settings for the Google sheet addon where it is adjustable. However, you probably want to look into SaasJet Issue history for Jira and see if it helps with your use case.

[Yuliia_Borivets__SaaSJet_]

Hi,

I am from the SaaSJet team; thank you for mentioning the Issue History for Jira. The app allows the creation of custom reports and exports the complete issue history for one issue/multiple issues/specific issue fields like statuses or another to Excel/CSV/PDF.

@Uwe Pilz you can read more about the export here: https://saasjet.atlassian.net/wiki/spaces/IH/pages/2358018057/Export+issue+history+data+from+grid+and+charts 

[Madhu_RVS]

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

[Aron Gombas _Midori_]

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__]

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