How to query Summary for EXACT match?

Timothy Harris May 18, 2017

Sio I want an exact match when using the contains operator in a JQL query. 

 

key = TEST-36 AND summary ~ "__SPU__"

 

However this seems to return anything with SPU also regardless of capitalization!

 

How to get an exact match?

3 answers

1 accepted

4 votes
Answer accepted
Thomas Schlegel
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 18, 2017

Hi Timothy,

this is not possible with current Jira versions. There is an open issue for that: 

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

Maybe you want to vote for it.

Timothy Harris May 18, 2017

sigh...

OK, well since I am calling it from script runner then I can use a regex to make sure it matches. 

 

But it is really irritating that the issue referenced has been open for 7 years. This should be supported by JQL :-(

 

Thanks for the reply!

Like Judith Richards likes this
Bilal Ahmed August 2, 2017

I have the exact requirement. Timothy, can you please elaborate on "calling it from script runner".

 

Thanks,

Kabeleced April 27, 2022

Should not the accepted answer - took me unnecessary time to read everything here to finally find (at least for me) the working solution further down.

28 votes
Brian Desany January 7, 2019

I love how this entire community is filled with posts that describe an issue, and they are all "solved" with the solution being "you can't do that".

Alex Koffler January 31, 2019

I wish I could upvote this 1000x more

Like # people like this
Anton Ukhanev March 18, 2019

@Alex Koffler , you can't do that.

Like # people like this
Like # people like this
Anton Ukhanev March 18, 2019

The anthem of Atlassian :D

Like Grigory Salnikov likes this
Ram August 24, 2020

seems like escape quotes work. summary ~ \"XYZ\"

Like # people like this
Georgi Mitov September 5, 2023

As of Sep 2023 - there is "kind of" a solution for Jira Cloud: 

use: summary ~ "\"search string\""

(described here: https://community.atlassian.com/t5/Jira-articles/Search-for-an-exact-phrase-with-JQL/ba-p/2131545)

 

How usable is this - is another topic. But at least there is a solution!

 

5 votes
kyona June 7, 2021

Hello everyone,

scriptrunner JQL function helped me solving that issue

issueFunction in issueFieldExactMatch(subquery, fieldname, regexp)

took from here

https://jira.atlassian.com/browse/JRASERVER-21372?focusedCommentId=2619612&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-2619612

Julian from AF October 14, 2021

Hello thank you solved for me !

Joshua Hopkins October 21, 2021

@Julian from AF

I have been reading documentation for days now trying to get scriptrunner setup. Any advice to help me get it working?

Julian from AF October 22, 2021

Hi @Joshua Hopkins ,

Yes see my screenshot :

image.png

In my case i use it in Jira Automation and it's working fine. 

To help you, you can use the website https://regex101.com/ to construct your regex if you need more than an exact match. To have an exact match, just put your text between ^and $ as shown but with regex101.com you can construct more precise.
image.pngimage.png

Is it clear for you? 

Julia July 26, 2022

Can someone help me understand why this query returns 16 tickets (14 of which are an exact match), but the below scriptrunner query does not work? Screen Shot 2022-07-26 at 11.51.36 AM.pngScreen Shot 2022-07-26 at 11.52.22 AM.png

Julia July 26, 2022

Screen Shot 2022-07-26 at 12.03.57 PM.png

Update: this worked. issueFieldMatch worked for me and not issueFieldExactMatch

Like Julian from AF likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events