“How to Increase Excel Export Limit for a Single Node in Jira Data Center (v9.12.8)?

[mahsa ah]

I’m trying to export issues to Excel using the Better Excel Exporter in Jira 9.12.8, but Jira limits the export to 1,000 rows. I want to increase this limit to 10,000, and although I updated the value of jira.search.views.default.max and jira.search.views.max.limit in the jira-config.properties file, the change doesn’t seem to take effect.

I’m aware that the limit can be changed via the web UI, but doing so would apply the change to all nodes in the cluster. I only want to apply this change to one specific node.

It’s worth noting that:

• The file permissions and ownership for jira-config.properties are correct.

• Other parameters in thus file are being read successfully by Jira.

Does anyone know how I can override this export limit only on one node?

These are the resources I’ve found so far:

• https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

• https://community.atlassian.com/forums/Jira-questions/How-do-I-change-the-max-limit-export-in-Jira/qaq-p/944786

[ShadowRoots]

To increase the Excel export limit on a single node in Jira Data Centre:

1. Edit jira-config.properties (create the file in $JIRA_HOME if it doesn’t exist).
2. Add or update the following property:

3. jira.search.views.default.max = [your desired limit]

Example:jira.search.views.default.max = 10000

1. Restart only that node for the change to take effect.

Important: This setting is per node, so changes on one node won’t affect others. Also, watch for memory/CPU impacts if you're exporting huge data sets.

Or if you're looking for a workaround, here it is:

1. URL Export Hack:
   Bypass UI limits by using this direct export URL:
   /sr/jira.issueviews:excel-all-fields/temp/SearchRequest.xls?jqlQuery=project= EXAMPLEProject
   Example:
   https://your-jira.com/sr/jira.issueviews:excel-all-fields/temp/SearchRequest.xls?jqlQuery=project=EXAMPLEProject
2. Limit Export via URL:
   Control the number of exported issues by adding &tempMax=100.
   Example:
   https://your-jira.com/sr/jira.issueviews:excel-all-fields/temp/SearchRequest.xls?jqlQuery=project= EXAMPLEProject&tempMax=2000

[Tinker Fadoua]

@mahsa ah 

Short answer is: you won't.

The one scenario your change will work if you only have one node in your DC. Otherwise you can not control the traffic through each node.

Best,

Fadoua