You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use Scriptrunner
and issueFunction in issueFieldMatch("Project = PROJECT-NAME", "Sprint", "SUBSTRING-FOR-SPRINT-NAME")
Richard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Amazing! But I also found that the performance of this JQL was slower, a better way is here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.