It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to query by ticket number range

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' ?

2 answers

1 accepted

7 votes
Answer accepted

Use the issuekey:

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

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

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).

Like Kenneth Sizer likes this

moved to answer to clarify

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

335 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you