Can we use "!~" operator with text field

[Rachit Singhal]

I have one business case where I need to look for the issues in entire Jira instance which is not having specific words in all text field like summary, description, comment etc. 

I have used text field many times with "~" operator which is one go search for all text related fields but I am unable to text field with "!~" with text field.

Does anyone come across the same scenario? 

[Trudy Claspill]

Hello @Rachit Singhal 

According to the documentation, that operator is supported.

Please show us exactly how you are using it (your filter) and explain to us how the results are not what you expect.

[Rachit Singhal]

Hello @Trudy Claspill ,

Yes, as per document it should work but it is not working for me. For example, it is giving me this error:

Please let me know if you need any other information.

Thanks.

Rachit Singhal

[Trudy Claspill]

Hm, I see the same thing when I try it in Jira Cloud.

I recommend you raise this directly to Atlassian Support to find out if it is a known bug.

https://support.atlassian.com/contact/

[Rachit Singhal]

Thanks @Trudy Claspill for your help.

[Trudy Claspill]

Following up on this, according to the Advanced Search Fields documentation the only operator supported for the "text" field is ~. So !~ is not supported for that field.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html

[Radek Dostál]

You can use the 'not' clause, like:

project = XYZ and not summary ~ "term to exclude"

[Rachit Singhal]

Thanks Radek but this query is not helping me.