Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to find exact match in a text custom field

Julie2.Stevens
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 10, 2023

I am trying to search a text custom field called Notes for an exact match.  The search I have is Notes ~ "\"Refinement in Progress\"" but this is showing me all issues that contain the statement in the notes field but what I want to see is only those where the the notes field contain that and no other text.  Is there a search where I can achieve this?

2 answers

1 vote
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 10, 2023

Hi @Julie2.Stevens 

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

If the feature that Jack mentioned doesn’t work as you wish, I have an alternative.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues whose Notes have the exact words “Refinement in Progress”

issue in wildcardMatch("Notes", "Refinement in Progress")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

1 vote
Jack Brickey
Community Champion
January 10, 2023

Hi @Julie2.Stevens , you might be interested in this In Progress issue - JRACLOUD-21372 Allow Exact Text Searching in JQL . Please note the latest comment about complexities with roll out.  It is not clear to me if the solution would achieve your goal of exclusion. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events