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_CONTAINbut can't find any solutions. What am I missing/overlooking? Thanks.

Community
Q&A
Jira
Questions
JQL - Does not contain operator (!~) usage

Jira project migration from one organisation to another

Looking for the best way to migrate a project from an existing organisation to a new organisation. can someone help with the available options.

3 answers

1 accepted

6 votes

Answer accepted

Try this one

!(summary ~ "(411)")

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Yes, this works! Thanks.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

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...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hello,

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

JIRA v7.5.2 (Server)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Try to query like this:

summary !~ "411*"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

could this have something to do with word stemming

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Jira project migration from one organisation to another

3 answers

1 accepted

JIRA v7.5.2 (Server)

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events