Increase issue limit for Excel exports in Jira Cloud
By default both JIRA issue navigator return a maximum of 1000 search results. Hence when exporting to CSV, JIRA will only export the first 1000 issues.
The maximum allowable value is dictated by the JIRA property 'jira.search.view.default.max' which is set to 1000 by default.
Currently, it is not possible to change this value as it falls under customization which is not allowed in Atlassian Cloud.
pager/start URL parameter to workaround this issue by adjusting the index value to export issues from 1001 onwards. You will need to merge the results manually.
- Run a search on the issue navigator to get all the issues need to be exported (Example below contains 200k+ issues).
- Export the first 1000 issues using the standard export feature (Export > Excel)
For the next thousand issues, right click on the same option above and open in new tab, you should get a URL string like below:
https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000 or https://<instance-name>/issues/?filter=<filter number>
Cancel the download, as we only require the URL string.
Append the &pager/start=1000 at the end of the URL string to instruct JIRA to export from index 1001 and above. You may need to append &tempMax=1000 as well. Example:
Visit this URL in your browser and save the file when prompted. For the subsequent 1000 issues, adjust the index value accordingly, for example
&pager/start=2000(and so forth).
- Open the exported CSV files and manually consolidate them if necessary.
If you encounter similar limitation for REST API, see Changing maxResults parameter for Jira Cloud REST API.