Filter based on range of issues

[Stephan Lewis]

Trying to figure out how I can filter for a range of issues based on their key.

For example IOS-1 thru IOS-999, then IOS-1000 thru IOS-1999.

I need this for running an automation on a set of issues - automations have a limit of 1000 issues.

My only workaround is to look for the created date of IOS-1 and IOS-999 and use those dates to create a date range filter

[Walter Buggenhout · Accepted solution]

Hi @Stephan Lewis,

You can perfectly use greater than or smaller than with issue keys, like this:

Project = IOS and key <= IOS-1000

 That would return the first 1000 issues. And the following:

Project = IOS and key > IOS-1000 AND key <= IOS-2000

would return the next 1000 issues. And so on.

Hope this helps!

[Stephan Lewis]

Works great - thank you!

[Mikael Sandberg]

You can use a JQL similar to this:

(key >= IOS-1 AND key <= IOS-999)