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,359,849
Community Members
 
Community Events
168
Community Groups

How can search results include part of a string?

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"?

2 answers

1 accepted

0 votes
Answer accepted

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

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

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

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".

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:

full-text-search-61.gif

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

Like Brian Sandler likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events