Increase issue limit for Excel exports in Jira Cloud

Still need help?

The Atlassian Community is here for you.

Ask the community

This article requires fixes

This article has been Flagged for fixing. Use caution when using it and fix it if you have Publisher rights.

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.

  1. Run a search on the issue navigator to get all the issues that need to be exported (Example below contains 200k+ issues).
  2. Export the first 1000 issues using the standard export feature: Export >> Export Excel CSV (output here will be in a CSV format)
  3. 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.

  4. 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).

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


Last modified on Mar 21, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.