Export More than 1000 Issues to Excel from Issue Navigator in JIRA Cloud

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to Atlassian's cloud products. Learn more about the differences between cloud and server.

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.

Cause

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.

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 need to be exported (Example below contains 200k+ issues).
  2. Export the first 1000 issues using the standard export feature (Export > Excel)
  3. 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.

  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 similar limitation for REST API, see Changing maxResults parameter for Jira Cloud REST API.

A bug ticket is tracked here: JRA-25493 - Getting issue details... STATUS  (Server),  JRACLOUD-25493 - Getting issue details... STATUS  (Cloud)

Description 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
Product Jira
Platform Cloud
Last modified on Dec 19, 2018

Was this helpful?

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