How can I set a fuzzy filter?

Question

According to the screenshot, I want to set a fuzzy filter to search the issues which the field "Release Tag" starts with"m-release-20220627", so that no matter it's “m-release-20220627-rc8” or “m-release-20220627-rc9”...will all be filtered. How should I set the filter?

mauricio.groth · Answer

Hi @tianchi

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your issues that contain "m-release-20220627"in the custom field “Release Tag”.

issue in wildcardMatch(“Release Tag”, "m-release-20220627*")

Check out the documentation for more examples.
I hope this helps!
Maurício

Petter Gonçalves · Answer

Hello @tianchi

thank you for reaching out.

If the custom field release-tag field is using the "Free Text Searcher", you can use the operator "~" (Contain) to execute a "fuzzy" match in a JQL filter:

"Release Tag" ~ "m-release-20220627"

P.S: Note that the search will return issues with the text string "m-release-20220627" at any part of the field, not necessarily at the beginning of the value.

You can check the documentation below for more details on the operator contains and how to run advanced queries:

Advanced search reference

Let us know if you have any questions.