Why does a filter for all tickets in a project stop prematurely at an earlier date?

[Steve Hooczko]

When I execute the following JQL, the data that is output in JIRA stops at July 20, 2023, instead of going to today's date:

project = Everest AND issuetype in (Story, Bug, Task) ORDER BY created ASC, key ASC

The number of tickets that are output = 1,000.

Is there a limit in JIRA to only output up to 1,000 tickets?

If there is no limit, why is this happening?

If there is a limit of 1,000, how can I retrieve/export the rest of the data?

[Sam Spencer]

Hi,

Yes there is a limit of 1000

At the bottom of the search you should see the per page number and total results number.

If more than 1000 you can click on this and see the full number of result, however still only 1000 will be returned.

The options I use are

1, Refine the query to bring it under 1000 and then have multiple queries to get the full results

2, (preferred) Use the free Jira / Excel plugin and run the query from there, you can set the number of result in the app - I have mine default set to 7000 and it has worked fine

https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?tab=overview&hosting=cloud

3, Use the API and configure pagination, a bit more complicated but provides more options for complex searches