How to use NOT in a text search?

Christian Barth [X]
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!
June 2, 2021

Hello,

I have the working advanced search

text ~ "Infosheet"

Now I want to find all issues that do NOT match this search. How do I do this? All my trails to add NOT or ! to this search either failed with the syntax or lead to no results (which is wrong)

Thanks,

Christian

 

1 answer

1 accepted

1 vote
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 2, 2021

Hi @Christian Barth [X], and welcome to the Community!

the keyword text searches across multiple field and does not support searches with not. However, if you adapt your search to target specific fields like Summary or Description, you can use this syntax:

description !~ Infosheet AND Summary !~ Infosheet
Bill Sheboy
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.
June 2, 2021

Hi @Christian Barth [X] -- Welcome to the Atlassian Community!

Adding to what Walter suggests, when checking for something which does NOT match a value consider if the field could be empty.  Such as for Description. Extending the above example that would be:

(description !~ Infosheet OR description IS EMPTY)
AND Summary !~ Infosheet


Best regards,

Bill

Suggest an answer

Log in or Sign up to answer