Unable to search for a string in Description

Amit Kapoor July 20, 2021

I have text like the following in Description.

|h4. Satisfaction Score|5|
|h4. Was Document Helpful|Yes|

 

As obvious, these are two rows of a table. Every issue gets different value in the range of 1-7 in Satisfaction Score. Now, when I try to find issues with value 5, I get the above. But I get the above even I search for issues using JQL

description ~ "Satisfaction Score|4|" OR description ~ "Satisfaction Score|3|" OR description ~ "Satisfaction Score|2|" OR description ~ "Satisfaction Score|1|"

How do I fix the query to return exact matches for score? And what am I doing wrong?

1 answer

1 accepted

0 votes
Answer accepted
Airbus Driver
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.
July 20, 2021

Try

description ~ "\"Satisfaction Score|4|\"" OR description ~ "\"Satisfaction Score|3|\"" OR description ~ "\"Satisfaction Score|2|\"" OR description ~ "\"Satisfaction Score|1|\""
Amit Kapoor July 20, 2021

It worked! Thank you so much. I totally missed the escape character.

Like Airbus Driver likes this

Suggest an answer

Log in or Sign up to answer