how to increase the export of issues to more than 2000 instead of 1000.

[ashok 1234]

Can some one help me this.

TIA..

[Orawan Sittakom]

Hi @ashok 1234

You can find document in https://confluence.atlassian.com/jirakb/exporting-a-filter-result-containing-more-than-1000-issues-191500982.html

However retrieving more than 1000 issues at once may result in an OutOfMemoryException for large result sets. This can cause database corruption or an application crash. You can use workaround below.

1. Right-click the URL for export (either "All Fields" or "Current Fields") and select Copy Link Location. The URL should be similar to:

http://localhost:8080/sr/jira.issueviews:searchrequest-excel-current-fields/temp/SearchRequest.xls?query=ER%5C+&summary=true&description=true&tempMax=1000

2. Paste that URL into a different browser tab.

3. Append the &pager/start=1000 at the end of the URL string to instruct JIRA to export from index 1001 and above (1000 rows). And click on Enter

http://localhost:8080/sr/jira.issueviews:searchrequest-excel-current-fields/temp/SearchRequest.xls?query=ER%5C+&summary=true&description=true&tempMax=1000&pager/start=1000

 4. Next export should append the &pager/start=2000 (change from &pager/start=1000 to &pager/start=2000) at the end of the URL string to instruct JIRA to export from index 2001 and above (1000 rows).

5. After that, open all exported Excel files and manually consolidate them into one Excel file.

[Joe Pursel]

This works! Follow these steps carefully.

Thanks https://community.atlassian.com/t5/user/viewprofilepage/user-id/692970

Joe

[Ollie Guan]

Hi @ashok 1234,

https://confluence.atlassian.com/jirakb/export-more-than-1000-issues-to-excel-from-issue-navigator-in-jira-cloud-779160811.html?_ga=2.25154552.355849122.1528444721-1937962263.1528444721

[david]

Hello @ashok 1234,

If can't or don't want to change anything in the Jira configuration, you can install this app that will allows you to export unlimited issues 

https://marketplace.atlassian.com/apps/1212073/exporter-export-issues-to-excel-csv-pdf?hosting=server&tab=overview

Cheers,

David

[Yogesh Mude]

HI @ashok 1234

Nope, the default search result limit is 1000 only, still, this can be impacted by jira performance.

so please refine your JQL and then try to export it.

[ashok 1234]

Can you provide JQL for that?

TIA