How can search results include part of a string?

[Brian Sandler]

I conducted a search on JIRA for issues for the string "6.1" and was unable to find an issue whose title contained "v6.1". When I search for "v6.1" that issue shows up. How can I get the search to return all issues whose title includes the substring "6.1"?

[mauricio.groth · Accepted solution]

Hi @Brian Sandler 

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 issues with a summary name containing "6.1". 

issue in wildcardMatch("summary", "*6.1*")

 Check out the documentation for more examples. 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Brian Sandler]

Thank you, I suppose this isn't a feature of JIRA natively and requires these extensions then. 

[Hannes Obweger - JXL for Jira]

Hi @Brian Sandler

hm, what view are you referring? In JQL (e.g., in the Advanced Issue Search), "summary ~ 6.1" seems to work for me. 

Best,

Hannes

[Brian Sandler]

I have an issue with the name "Something something v6.1".

When I search for "6.1" in JIRA (basic) it doesn't return the issue but when I search for "v6.1" it does. I tried executing the JQL (switching to JQL mode) "summary ~ 6.1" but this did not return any issues despite there being multiple containing the string "6.1" and "v6.1".

[Hannes Obweger - JXL for Jira]

Ah, understood, I think it only worked for me because the "6.1" was a word on its own. JQL's text search depends on an underlying text indexing system, which unfortunately makes certain searches very difficult or even impossible.

As you already said above, you'll need a Marketplace app for that. Just to put another option out there, this also works fine in the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issues fields. It also comes with Excel-style column sorting and filtering (among many other things). As this filtering uses a different technology than JQL, searches like yours work fine; this is how it looks in action:

As you can see above, you can work with your issues directly in JXL, or trigger various Jira operations, or export your issues for further processing.

Hope this helps,

Best,

Hannes