Jira issue filter contain text with partial words

[Bernat Casero]

On issue navigator there is a text box to filter issues. When I put an incomplete word (ie: inter) searcher show no results. There are issues with International word on subject.

Can I change the behaviour of this text box to allow incomplete word search?

regards

[Geert Graat · Accepted solution]

Hi,

You can search using the CONTAINS operator. So for example:

summary ~ "inter*"

Regards,

Geert

[Bernat Casero]

perfect! it woks

[Lewis Chilton]

It does need speech marks or asterisk;

summary ~ inter

Should work fine as it automatically searches using the contains operator.

[james_mckean]

That works if your search term begins with a known value, but not is the value is embedded inside the string, because a search term cannot begin with a wildcard.  If you are looking for "something-345-something" and the only think you know is 345 then text ~ "*345*" does not work.  I am not sure how to find that.

[michael shelnutt]

Geert 

This is not working for me at all....

I have a Summary field that has the text of DEF_LIST_272 Foo Bar   

I want to find my issue by looking for 272

If I use summary ~ "272*"  I get no results back

In fact , if I use 

summary ~ "DEF_LIST_*"   I still get no results back

if I use 

summary ~ "DEF_LIST_272" I get results back.

So is there a real CONTAINS feature (i.e. contains the text, like GREP does)?

[Christopher Pearson]

I was having he same issue with a simalare keyword search. This is what i had to do to make it work. It appears it doesn't match up if it has underscores (dont think that is the only case it cant find the keyword...). So i broke it up into several phrases. Also, the '*' doesn't seem to work even thou they say to use it on their guide...

change: Summary ~ 'DEF_LIST_272'

to: Summary ~'DEF_' AND Summary ~'LIST_' AND Summary ~ '272'

This will probably return you some extra items but will also bring back the results you are looking for.

[Nithin Balachandran]

It worked well for me !! I used  summary ~ "Text"

[Deleted user]

I had the same problem. The search in JIRA is sadly not that good. Wanted to search for a number in a string, e.g. test123 and couldn't find it with any option. Of course you can try like Christopher Pearson said, but you really have to know the whole string and not only a part of it.

There is an add-on called Power JQL (https://marketplace.atlassian.com/apps/1216891/power-jql-extended-search-functions?hosting=server&tab=overview) from our company which can solve this problem. For your issue michael shellnutt try following jql search

for issue in powerIssue("summary", ".*272.*")

This gives the result you desire.The add-on can improve the jql search also by using  RegEx in its full potential. You can also search for attachments on issues.

[David Tefft]

I know this issue is a bit old but I ran into it myself and found this works best for me.  This only works if you have Adaptist Scriptrunner installed.  This does mean you have a dependency on Scriptrunner but it has so many useful features it's totally worth it.

This will do a partial search for 272.  It doesn't matter if the string 272 is at the beginning, middle or end.  It also allows for regular expressions.

issueFunction in issueFieldMatch("project = SM", "summary", "272")

[Quentin CHEVALIER]

Hi,

Note that you need to escape some  caracters, like the "[". Maybe because the operator "~" is base on regex?

For exemple if you want look for "[KEY]" you need to write : summary ~ "\\[KEY\\]"

[Łukasz Uliasz]

when I write 

summary ~ "\\[KEY\\]"

Jira also finds results that have "KEY" not surrounded by "[" and "]" :(

Edit: Nevermind, I found in Jira documentation that "Special characters aren’t stored in the index, which means you can’t search for them. The index only keeps text and numbers (...)" 😞

https://confluence.atlassian.com/jirasoftwareserver087/search-syntax-for-text-fields-998873824.html 

[ahmed.belhadj]

Hello Folks :)
Actually, noticed that if the search string contains part of the word, the search fails (does not return result).
So, I think this is a bug that Atlassian should fix.
Example :

project = "Orange Reunion" AND summary ~ "COMREQ_" ==> Does not return any result
project = "Orange Reunion" AND summary ~ "COMREQ_BUS_040" ==> returns result

Knowing that the searched case hase a summary :

"COMREQ_BUS_040 Achat Gérer des prospects - Storing shopping carts of prospect customers" without the ""

[Peter Schmidtke]

sort of sad that you need always third party tools (that are quite expensive as well) to do all of these basic things :(

[Reg Hawkins]

project = <projectname>AND issuetype = Task AND summary !~ "FT Manual testing" AND summary ~ "Manual testing"

This searches the summary and removes all the tasks that contain "FT Manual testing", if I d "Manual testing" I get all the issues that also include FT.

The only drawback with this approach is that I am relying on the summary being consistent.

[Richard Smart]

Just noticed this does not work if you use [ ] - I get an error returned of text query '[text here]*' for field 'summary' is not valid: probably your range query is incorrect.

[suresh Jayaraman]

Following