nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Searching an issue which matches exactly the given words.

Mohit Gupta8

Hello,

I was searching some issues in JIRA by applying a filter and I provided three words in the Query field lets say that ( JIRA is good).

When I hit search, I am getting result based on all the words like the Summary conatining only JIRA is also coming in search result and Summary containing only good is also coming in search result, but what I want is the search result which contains only those with Summary containing all of the above three words in combination.

According to me, Summary should contain only search result with above three words at any place any order

What query should I apply to achieve this result.

Thanks

Mohit

Accepted answers

All comments

Norman Abramovitz

See if this works for you.

summary ~ JIRA AND summary ~ is AND summary ~ good

Norman Abramovitz

You probably need double quotes around the word is since is an operator as well.

grundic

summary ~ "JIRA is good"

As Norman said, you have to use double quotes to search exact phrase.

Norman Abramovitz

Does that actually work for you? I have tried it out since version 4.4 (when I started to use JIRA)and it generates results more like field contains word1 or field contains word2 or field contains word3 which is the behavior that Mohit was complaining about.

The reason for questiong, is because maybe there is an option that people can turn on.

Norman Abramovitz

Oh, the default search indices has an ignore word list, so the word "is" may not match.

Norman Abramovitz

Grigory's response gave me another thought on how to make it work. Please try

summary ~ "\"Jira is good\""

The escaped inner quotes contains the search term while the outer quotes deals with the navigator syntax.

grundic

My bad - I was wrong. According docs you have to use fuzzy search to get exact match like this:

summary ~ "\"JIRA is good\""

Double quotes inside query have to be escaped.

Sorry for incorrect answer at first.

Hope, this helps.

dibenedetto

This doesn't work. Try a two-word phrase with a freshly created issue. I'm getting hundreds of results when I should only be getting 1.

Orion Elenzil_60xosw

lots of up-votes for this answer, but i still just get tickets with "Jira" and also "good" but not "Jira is good".

Orion Elenzil_60xosw

users to atlassian...

JB_bau4nn

Please Atlassian give us a method for >>exact<< searches. Thank you.

Former user

Yeah, not sure what the up-votes for. This doesn't solve the issue at all.

Balu_socnwf

for me this worked:

text ~ "\"Jira is good\"~0"

Joel Marriott

Would just like to upvote this working answer. (v7.3.2)

Former user

Maybe it works for Server, for Cloud it doesn't work. The result is an "All the strings" result but no Exact Match.

JB_bau4nn

I just retested Cloud on the off chance that something has changed. This solution is still equivalent to

text ~ Jira and text ~ good

which returns all issues with both the word Jira in them and the word good in them, rather than only issues with the exact text "Jira is good" in them.

This isn't what the OP (& the rest of us) is asking for at all.

Justin Bowen_jcvab4

I can't believe that it's possible for Atlassian to have raised $462 million in their IPO 4 years ago and yet Jira still doesn't have a working (nevermind simple/common sense) exact phrase search. Am I just missing something...? Was there $10k in the budget to get this working? I'm sure more than $10k worth of clients would appreciate it.

Ford Prior

Reading this thread is unbelievable. I honestly think whoever from Atlassian is replying still doesn't understand this issue being described.

Pete Smith_bsqzwp

Can I force a search to be case-sensitive? That would get me a bit closer to my target

unknown

I'm not sure why it did not work for you, but it seems to have worked for me.

I hope you found a solution.

Doğucan Baskın

So Atlassian is providing a solution which does not work. Isn't it a bug actually?

Former user

No, that's normal state of affairs.

unknown

try this, I think I have gotten this to work sort of.

summary ~ \"jira\ is\ ok\ I\ guess\"

Escaping the quotes, and escaping spaces.

Doğucan Baskın

So for the comments that includes "You can close" should be:

comment~ \"You\ can\ close\"

This one giving me the same result with comment~ "You can close".

Tom_c3wl17

That would still produce a match for the phrases:

"Good is Jira"

"Nothing is good about Jira"

"Jira needs To fix this for good because it is annoying"

Tom_c3wl17

The funny part is that it does not even take a multiple word scenario to cause it..

Searching for "summary ~ "FT#3"

matches a description "FT#4 for server number 3"

Even if you use all of the clever quote escaping above it still matches. So I cannot even query for a simple one word phrase

Sandra Kawamoto

It is a known issue with Jira Cloud. They are gathering interest. Please, vote and comment if you are interested in this fix/implementation.

https://jira.atlassian.com/browse/JRACLOUD-21372

https://jira.atlassian.com/browse/JRACLOUD-69263

Jordan Nimlos

I, too, find it very frustrating that there is not a better way to do an exact search on text fields in JQL. I have a use-case for this where I need to make sure my JQL query returns only 1 issue as I know there is only one where the summary exactly matches my search term, with no extra terms outside of that. I tried things that others suggested here, like:

summary ~ "\"Sample text\" NOT \"Sample\ text\ *\""

and

summary ~ "+\"Sample\ text\" -\"\ *\"~0"

but nothing works. It either returns nothing, or it returns my desired issue and other issues with summaries like "Sample text abc".

After banging my head against the virtual wall for a while this morning I remembered that Scriptrunner has an issueFieldExactMatch() function built-in. I just tried it out and it worked beautifully, no special syntax or escaped characters required. You can use

issueFunction in issueFieldExactMatch('<some JQL subquery>', 'summary', 'Sample text')

Specific documentation on usage here. I agree that Atlassian should provide a better way to do exact search on text fields and that it is ridiculous that they have not yet done so. However, Scriptrunner is quickly becoming my favorite add-on and it is one of the more affordable plugins out there, arguably one of the best value for the money for how powerful I've found it to be.

If your workflow depends on an exact text field match, I suggest looking into that.

Alexey Miroshnikov_f24mvy

Sounds promising, but I personally get

"Field 'issueFunction' does not exist or you do not have permission to view it."

error message in cloud Jira.

Jordan Nimlos

If you have Scriptrunner for Jira Cloud, it looks like this is still possible but you may have to enable "enhanced searching" to use issueFunction: https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_issuefieldexactmatch

Steve D_bg4afj

I stumbled on a similar problem today and found something that works for me.

A basic search on:

"\"Exact Text To Match\""

with the surrounding quotes included will produce results with only the tickets that contain the text 'Exact Text To Match'.

This can then be translated to the following, rather chaotic, advanced search condition:

text ~ "\"\\\"Exact Text To Match\\\"\""

Jawann

Hmmm doesn't work for me in Jira Cloud. I get the same number of results as a simple text search with no quotes or anything.

Steve D_bg4afj

We are running JIRA server v7.2.2. I don't use cloud, so I am not sure if this difference is between the server and cloud implementations of if something changed in a newer release, as our version is over 4 years old at this point...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

issue

jira

jql