JQL Filter doesnt work as expected

[Andreas Kemper]

Hello everyone.
I'd like to use this JQL filter: "project = 'XXX' and key > XXX-100 and key < XXX-200 ORDER BY key ASC".
I want to see all tickets whose key lies between XXX-100 and XXX-200.
However, Jira only accepts this filter if the tickets for the lower and upper limit actually exist.
This is problematic because I don't know the exact key of the first and last tickets in the queried range. Maybe, ticket XXX-100 doesn't even exist.

Background: I want to retrieve all tickets for a project via API. This is only possible in blocks of 100 because the API has a "maxResult = 100" limit.

Any ideas?
Suggestions?
Solutions?

Thanks a lot, best regards, and have a great start to the week!

Andreas

[Florian Bonniec]

Hi @Andreas Kemper 

It do not work because JQL compare to issues in the index, if the issue XXX-100 do not exist it cannot use it for comparaison.

If you want to retrieve all tickets from a project you do not need this, you can use this endpoint

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-get

You have then nextPageToken in teh response to fetch next page if any.

Regards