How to Prevent Users From Exporting Large Number of Issues to Excel Which Causes Slowdowns (while still allowing admins to bypass the limit)

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

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.

Solution

  • 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

    http://localhost:8711/sr/jira.issueviews:searchrequest-excel-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=100

    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:

    http://localhost:8711/sr/jira.issueviews:searchrequest-excel-all-fields/temp/SearchRequest.xls?jqlQuery=&maxResults=99999

 

Last modified on May 6, 2016

Was this helpful?

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