How to Prevent Users From Exporting Large Number of Issues to Excel Which Causes Slowdowns (while still allowing admins to bypass the limit)
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
In some cases general users might try to export a large number of issues to excel which causes slowdowns and affects all other users. JIRA Administrators might want a way to limit or prevent general users from being able to export large number of issues to excel.
The information in this page relates to customizations in JIRA. Consequently, Atlassian Support cannot guarantee to provide any support for the steps described on this page as customizations are not covered under Atlassian Support Offerings. Please be aware that this material is provided for your information only and that you use it at your own risk.
Also, please be aware that customizations done by directly modifying files are not included in the upgrade process. These modifications will need to be reapplied manually on the upgraded instance.
- Create a file named jira-config.properties (if the file does not currently exist) directly under JIRA Home
In jira-config.properties, set the following parameters
jira.search.views.default.max=100 jira.search.views.max.limit=100 jira.search.views.max.unlimited.group=jira-administrators
- The above example will limit the number of issues that all users can export to 100 at one time, but allow users in jira-administrators group to bypass the limit
Users in jira-administrators group can bypass the limit by modifying the URL:
Right click Export > Excel and copy the URL, for example
Change the end of the URL (replace tempMax=100 with maxResults=99999) such as the example below and enter the URL in browser to export the excel file: