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 

[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

[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