export all issues and all related fields for each issue type from Jira Server to Excel

vcatl2020

Our management is asking for exporting of all 100,000+ issues with all related fields including comments or activities associated to each issue type (100+) from all projects into an excel/csv/html spreadsheet. Is there is a feasible way through native Jira, Sql query/view or addon that would help to accomplish the exporting of this data?

Mohamed Benziane

Hi,

The first question is why do they need to export all theses issues ? 

You could use REST API and play with the startat maxresults parameter to achieve this.

https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

 

Hope this helps