Increase issue limit for Excel exports in Jira Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Problem
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.
Environment
Jira Cloud only
Cause
The maximum allowable value is dictated by the JIRA property 'jira.search.views.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.
Workaround
Use the 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 that need to be exported (Example below contains 200k+ issues).
- Export the first 1000 issues using the standard export feature: Export >> Export Excel CSV (output here will be in a CSV format)
For the next thousand issues, right click on the same option above and open in a 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:
https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000
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.
Other Info
If you encounter a similar limitation for REST API, see Changing maxResults parameter for Jira Cloud REST API.
A bug ticket is tracked here: - JRACLOUD-25493Getting issue details... STATUS (Cloud)