Issue Summary

The current limit for export in the Excel integration is causing issues for customers who need to query larger sets of data.

According to this documentation, the suggestion is to export 10,000 issues at a time, however, at times, it is necessary to export more rows for reports, forcing users to break the search and double or triple the work depending on the amount of data to be retrieved.

Steps to Reproduce

1. The user creates a JQL query that exceeds the limit of data to be retrieved.
2. The user attempts to export the query results to Excel.

Expected Results

The JQL query, regardless of size, is successfully exported to Excel, including all queried fields and data.

Actual Results

When the query exceeds the current limit, an error message is displayed and the export fails. The log file shows a GeneralException error.

The below exception is thrown in the xxxxxxx.log file:

GeneralException. Please try again.

Workaround

Currently, the workaround suggested is to reduce the number of fields to export or add filters in the query to break the data.

For instance, if you are trying to fetch tickets assigned to a person, you may want to add a filter to check for issues for that assignee created before a determined date.

Before:

1. assignee = currentUser()

After:

1. first search: assignee = currentUser() and created >= '2024-01-01' and created < '2024-06-01'
2. second search: assignee = currentUser() and created >= '2024-06-01'