Search for an exact phrase with JQL

[Akira Higuchi]

@Narsha Bachoo 

I tested the following JQL and got the same result.

text ~ "\"SCPR-\""

text ~ "\"SCPR\""

"-" is a special character, so I don't believe it is stored in the index. The documentation for the Data Center clearly states this, but the documentation for the Cloud has lost that mention. I don't know why.

[Slava Gefen]

and yes I do have scriptrunner installed

@Narsha Bachoo that's great! 👍

In Data Ceneter we could use something like this:
Search syntax for text fields | Jira Software Data Center 9.15 | Atlassian Documentation

summary ~ "SPCR-*"

But it's deprecated in Cloud unfortunately
Search for issues using the text field | Jira Cloud | Atlassian Support

But then you can use this Script Runner Enhanced Search example:

issueFunction in issueFieldMatch("project IN (STAR, SD)", "summary", "^SPCR-*")

That will give you the same result in Cloud.
Here is my example with usual JQL

summary ~ "\"Sub-*\""

That gives all results with "Sub-" even not in the beginning:

And here is the example of Script Runner function

issueFunction in issueFieldMatch("project IN (STAR, SD)", "summary", "^Sub-*")

That gives the desired result:

Documentation is here:
JQL Functions (adaptavist.com)

Hope it helps!

With kind regards
Slava

[Narsha Bachoo]

Hi @Akira Higuchi

Thanks but it is not working for me. I am not getting the expected results.

Hi @Slava Gefen

This is working as expected in scriptrunner. Thanks for your help!

Regards,

Narsha

[Steven Lees-Smith]

This just doesn't work but it is still included in the Atlassian official doco.

The exact phrase match still just seems to work as a wild card search.

summary = "\"This is a test\""

Will return

This is a test

This is another test

[Slava Gefen]

Something isn't good with your settings, @Steven Lees-Smith .

First of all, this is a mistake

summary = "\"This is a test\""

You'll get an error:

But the wildcard with double quotes will give you only one result:

And finally, usual wildcard will give you the result you mentioned:

Hope it helps!

With kind regards
Slava