Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,631
Community Members
 
Community Events
176
Community Groups

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

2 votes
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.

This returns the issue under that sprint. not returning the sprint itself.

Like Matt Otto likes this

Use Scriptrunner

 

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

 

Richard

Amazing! But I also found that the performance of this JQL was slower, a better way is here 

https://community.atlassian.com/t5/Jira-questions/Is-there-a-way-to-use-the-sprint-name-as-part-of-a-query/qaq-p/51463 

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events