Workaround for Exporting More than 1000 Rows of Data

[Emily Smokoff]

Hello all,

I am currently trying to figure out how to export more than 1000 rows of JQL results in Jira to an excel file. It is flagging an error that I cannot export more, I saw some advice to copy the link address and change the tempmax, but when I did that the file was still undigestible when downloaded. Does anyone have any suggestions, or any ideas on how to return a count of the results produced in a JQL query that is then exportable?

Thanks!!

[Radek Dostál]

The workaround you mention works (I know because I used it several times here and there), so perhaps you just misapplied the parameters. (This one I think? https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html)

Server has it's own KBA where you can change that limit though (or bypass it for specific user group, e.g. jira-administrators and such) - https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

However you might want to first try exporting a huge data set in a test environment - it's true that after 8.2 the memory problems are not that much of a threat anymore, but it always depends on your server specs at the end of the day.

[Emily Smokoff]

Awesome that worked! Thank you for your help. I had been using a different workaround then the one you mentioned, but this one works like a charm!