How to query by ticket number range

[nathanwendling]

Trying to figure out how to get all tickets in a range, e.g. if the tickets are for project abc and issue numbers 400-410 all need changes, can I at least query a list where I only see abc-400, abc-401, ..., abc-410?  something like 'project="abc" AND *unknownFieldName* > 409 AND *unknownFieldName* < 411 ORDER BY *unknownFieldName* DESC' ?

[Sebastien Jacques · Accepted solution]

Use the issuekey:

issuekey > ABC-409 AND issuekey <= ABC-411

[nathanwendling]

Thanks, didn't realize that those were allowed on strings in JQL, after all the trouble I had earlier trying to use ~ on things.

[js-shm]

Thanks

[Russell Warren]

This does not work (at least currently) if one of the keys used n the limit does not exist.

For example:

issueKey > ABC-409 AND issuekey < ABC-411

will not work at all if either one of `ABC-409` or `ABC-411` doesn't exist either (has not been created yet, or has been deleted).

[Mark H_ Williams]

I switched the AND to OR and it worked

[Lynne Randolph]

moved to answer to clarify