JQL - Does not contain operator (!~) usage

[Raj Vora]

I am trying to use the Does Not Contain operator to identify any issues in my entire JIRA instance where the Summary does not contain the word "411";

So my JQL statement I use is (summary !~ "411"), while this seems straightforward, the search still generates results that have the "411" string in the summary.

I read the advanced searching page here:

https://confluence.atlassian.com/jira064/advanced-searching-720416661.html#AdvancedSearching-KeywordsReference-DOES_NOT_CONTAIN

but can't find any solutions.  What am I missing/overlooking?

Thanks.

[Mahesh Patel · Accepted solution]

Try this one

!(summary ~ "(411)")

[Raj Vora]

Yes, this works!  Thanks.

[Phil Bustin]

This isn't working for me: !("SBM Tracking No" ~ "K")

[Amir Katz (Outseer)]

See the answer by Ignacio Pulgar (May 9, 2018) in this thread:

https://community.atlassian.com/t5/Jira-Core-questions/Search-for-issues-that-do-not-contain-text/qaq-p/455633

The secret ingredient is how to use the filter:

<some-criteria-here> AND FILTER NOT IN (<filter-ID>)

Definitely counter-intuitive IMO...

[Alexey Matveev]

Hello,

What is your Jira version? I just tried on Cloud and it worked.

[Raj Vora]

JIRA v7.5.2 (Server)

[Alexey Matveev]

Try to query like this:

summary !~ "411*"

[Raj Vora]

unfortunately that doesn't fix it either; not sure if it has to do with the fact that I am searching based on numbers

[Raj Vora]

could this have something to do with word stemming

https://confluence.atlassian.com/jirasoftwareserver075/search-syntax-for-text-fields-935562918.html#Searchsyntaxfortextfields-limitations

[Alexey Matveev]

Could you give me examples of issues which you can see, but they should not be selected?

[Raj Vora]

The summary for a few issues that appear in the search results but should not:

Issue 101 - 85411 - Something is wrong
Issue 102 - 85411 - Something is wrong again
85411 - Something is still wrong

[Alexey Matveev]

That is right. You are not able to filter these issues out because Jira looks from the beginning of the words in the summary field.

For example 

Issue 101 - 41123434 - Something is wrong

would work.