How do I query on a particular field which is ending with a particular keyword.
Eg. I want find all the projects ending with "IES", we use %IES in SQL, but in JIRA it doesn't support % or *. So please let me know if I have to find all projects either starting with IES or ending with IES then how do I query ?
Hi @Hari ,
just noticed this long outstanding open question.
Perhaps you already found the answer, perhaps not, but as it is a short one, here goes:
Jira supports wildcard searches for textfields, eg:
summary ~ "prio*"
But not for other fields, like the Project.
There are some workarounds, like using a project category, or using apps, you might want to look into other questions like: https://community.atlassian.com/t5/Jira-questions/Wildcard-search-on-jira-and-projects-in-particular/qaq-p/839920
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