JQL Filter doesnt work as expected

Question

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

Daniel Turczanski · Answer

Hey @Andreas Kemper You can get 5000 issues only if you ask for the id,key fields. Any other fields will limit the page to 100 issues

See the documentation of maxResults query paremeter here https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-get

What's your use case and why do you want to get all the tickets for the project?

Andreas Kemper_8h9ltw · Answer

@Akash Singh Thanks for your comment. Unfortunately it doesnt work for me. I'm sure I do sth wrong but I have no idea so far.

I followed your advise and used the 'fields' param in my jql. =>
"https://our-domain.atlassian.net/rest/api/3/search/jql?jql=project = 'PP' and type = 'Story' ORDER BY issuekey ASC&fields=summary&maxResults=200"
The result is ok but still limited to 100 entries.

Akash Singh_vujl0e · Answer

@Andreas Kemper Building on @Florian Bonniec’s answer, you can increase the number of issues returned in a single response by restricting the payload to only the fields you actually need. This can be done using the fields parameter along with maxResults, which allows you to fetch up to 5,000 work items per request. For larger result sets, you can retrieve subsequent pages by using the nextPageToken value returned in the response. Your API endpoint would look something like this: curl --request GET \ --url 'https://your-domain.atlassian.net/rest/api/3/search/jql?jql=project%20%3D%20HSP&nextPageToken=&maxResults=5000&fields={fields}' \ --user 'email@example.com:' \ --header 'Accept: application/json'