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?
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.
Hope this helps
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events