Problem

By default the Jira issue navigator will only return a maximum of 1,000 search results.

Hence when exporting to CSV, Jira will only export the first 1,000 issues.

Environment

Jira Cloud only

Cause

The maximum allowable value is 1,000 set by the Jira property ‘jira.search.views.default.max'.

It’s not possible to change this due to customization rules in Atlassian Cloud.

Workaround

Use the  pager/start URL parameter to adjust the index value. You can then export issues from 1,001 onwards.

You’ll need to merge the results manually.

1. Run a search on the issue navigator to get all the issues that need to be exported (This example has over 200,000 issues).

   1. 

2. Export the first 1,000 issues using the standard export feature: Export >> Export Excel CSV (CSV format)

   1. 

3. Rolling out over the next few weeks: CSV export is becoming asynchronous. This means you would see a faster and dependable export showing export progress where you need to retrieve the URL differently as follows.

           Current synchronous experience:

• Right-click on the export option, open it in a new tab.

• Cancel the download. Copy the URL.

         New asynchronous experience:

         For the next 1,000 issues right-click on the page and choose 'Inspect'. This will open the developer tools.

• Go to the 'Network' tab, select 'Fetch/XHR'

• Enter views in the filter.

• Next, refresh the page and select the Export dropdown menu.

• Copy the URL from the link field of the corresponding export option in the ‘Preview' tab. Here’s an example:

https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000
or
https://<instance-name>/issues/?filter=<filter number>

      4. Append &pager/start=1000 at the end of the URL string. This tells JIRA to export from index 1,001 and above. You may need to change &tempMax=1,000 as well. Example:

https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000

         Paste the URL in your browser and save the file when prompted. To see more than 1,000 issues, you’ll need to adjust the &pager/start= index value e.g. If you want to export the next thousand issues 2,000 issues you’d change it to &pager/start=2002

     5. Open the exported CSV files (you may need to manually consolidate them).

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-25493 - Getting issue details... STATUS (Cloud)