Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

wildcard query for sprints

We name our sprints with a code name and date numbers (for example ABC-200221). I need to create a filter that will capture all sprints beginning with the same letters. How can I do that in JQL? 

2 answers

1 accepted

1 vote
Answer accepted

Hello Donna,

Thank you for reaching out.

Although the Sprint field does not support wildcard search (Using "~"), you can return all the Sprints that begin with specific characters by simply using the "=" sign and specifying the characters, as explained in this documentation:

The search is based on either the sprint name or the sprint ID (i.e. the number that Jira automatically allocates to a sprint).

If you have multiple sprints with similar (or identical) names, you can simply search by using the sprint name — or even just part of it. The possible matches will be shown in the autocomplete drop-down, with the sprint dates shown to help you distinguish between them. (The sprint ID will also be shown, in brackets).

That being said, the query below should work for you:

Sprint = ABC

Let us know if you have any questions.

Use Scriptrunner

 

and issueFunction in issueFieldMatch("Project = PROJECT-NAME", "Sprint", "SUBSTRING-FOR-SPRINT-NAME")

 

Richard

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

761 views 24 28
Read article

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