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

vcatl2020 March 18, 2021

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?

1 answer

1 accepted

1 vote
Answer accepted
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2021

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

vcatl2020 March 19, 2021

Hi @Mohamed Benziane

Well it is still a million dollar question on why do they need ALL issues w/ fields :(

Meanwhile, I tried exporting first 1000 issues w/ ALL fields by adding &tempMax=1000 to the URL and the data view looks so odd, as it added 1024 columns in the export file for each issue, lol,lol...

I will run this by our management to find out if it makes any sense and keep you posted.

Like Dave Rosenlund likes this

Suggest an answer

Log in or Sign up to answer