!~ operaror not working in query

[jwarming]

I have a cutom query for a queue like this that works perfectly

assignee in (currentUser()) AND resolution = Unresolved AND text ~ QQQ

However this one gives me an error

assignee in (currentUser()) AND resolution = Unresolved AND text !~ QQQ

If QQQ is not found in the text I dont want it in the queue.

[jerson gevera]

I have same problem, for some reason !~ will only work on specified fields summary and description only

 assignee = currentUser() AND summary !~ QQQ AND description !~ QQQ 

Maybe because text and comments are returning multiple values thats why it did not work 
if theres like array kind of reading maybe it will work 

[jwarming]

Hi Trudy,

Same issue was raised here:

https://community.atlassian.com/t5/Jira-questions/Can-we-use-quot-quot-operator-with-text-field/qaq-p/2135011

[Trudy Claspill]

Hello @jwarming 

Welcome to the Atlassian community.

What error are you getting? Are you getting an actual error message, or are you getting results that don't match your expectation?

Using "text" means that many text fields in the issue will be searched as per the documentation here:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#DOES-NOT-CONTAIN-----

Do any of the specified fields or any of the comments include "QQQ" in some form? If so, then those issues will NOT be included in the results.

[Trudy Claspill]

I have reviewed the documentation for searching with the "text"field, and it states that the !~ operator is not supported for that field.

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Text

The only supported operator is ~.