Search for issues that do not contain text

I need a simple solution for a JQL

eg: 

issuetype = Bug AND text != Apple

 

the != operator is not supported with text search. 

4 answers

1 accepted

This widget could not be displayed.

issuetype = Bug AND summary !~ "*On Production*"

Try with 'text' instead of summary, as I can't test now if it works as well.

Thanks, but no. Text does not accept != as an operator. 

Dave, !~ is different from !=

Thanks! !~ works perfectly.

I cannot get the !~ to work with the text field. It works in summary, but does not appear as an option for text searches. If you force it, it doesn't work.

Why is this the accepted answer? 'text' and 'summary' are different fields in JIRA. The OP is asking about the 'text' field which does not support the !~ operator.

Agree.  This answer is completely wrong and should be un-accepted.  You cannot use "!~" on text.

How can I negate a match on text?

This answer does not work for 'text'... should not be marked correct

Have just stumbled upon this old answer and felt the necessity to correct it, as suggested.

However, for consistency with the dates of previous comments, I'll post the correct answer within this comment instead of editing the original answer:

You can get all issues that do not contain the word 'Apple' by following these steps:

  1. Execute the following JQL: text ~ Apple
  2. Save your search as a filter, ie named "With Apple".
  3. Finally, execute this new JQL: filter not in ("With Apple")

After that, you'll get the list of issues that do not contain the word 'Apple'.

My original answer stated I didn't test it, so I was probably answerring posting from my mobile phone...

My main point was that '!~' should be used instead of '!=' with text fields.

As text function is sometimes used as a lazy way to avoid having to write longer JQLs which actually would target Summary and Description fields, some people might have found the correct syntax of DOESN'T CONTAIN '!~' a useful answer every now and then.

But, of course, the correct answer is the one I've just included into this comment.

Sorry for not having noticed this mistake before!

Best regards.

Can confirm Ignacio Pulgar [Tecnofor]'s comment, this is an acceptable solution for searching "Does not contain this text". I do not know why, but it seems that the !~ operator does not work for text. 

 

As a note to this solution, you will likely have to include the majority of your search in the second query, see below example as an explanation.

You run a bakery and track your recipe creations in JIRA. The project is MyBakery, your epics are a custom issuetype called Recipe, and you want to find all of your recipes that do not contain Apples.

This will return all of your project specific recipes that include the word apples.

project = MyBakery AND issuetype = Recipe AND text ~ Apples

Save this as a filter, for this example, the filter name is 100.

 

In a new query, you can write...

filter != 100

This will return EVERYTHING in JIRA that is not in that filter. So to have it specific to your search you would rewrite the first half of your first search.

project = MyBakery AND issuetype = Recipe AND filter != 100

This will return all of the appropriate items that are not including the text Apples. 

 

Additionally, you can add multiple text options to mask out. If you had a customer who was allergic to Apples and Bananas, you could put in the first query 

project = MyBakery AND issuetype = Recipe AND text ~ "Apples OR Bananas"

 

Your JIRA version will dictate the correct syntax, see https://community.atlassian.com/t5/Answers-Developer-Questions/How-can-i-use-the-like-operator-with-the-List-of-values-in-Jira/qaq-p/545519 for reference.

This widget could not be displayed.

?? Opposite of my need. Using ~ would result in what issues I do not want to see. 

If I have 100 cake recipes, of many various kinds, but hate Apples and don't want to see any of the recipes that include the use of Apple. 

examples:

~ Apple = show me recipes (issues) with Apple in them

!~ Apple = do not show me recipes (issues) with Apple in them

 

I want a JQL for the latter of these examples. 

This widget could not be displayed.

Can confirm Ignacio Pulgar [Tecnofor]'s comment, this is an acceptable solution for searching "Does not contain this text". I do not know why, but it seems that the !~ operator does not work for text. 

As a note to this solution, you will likely have to include the majority of your search in the second query, see below example as an explanation.

You run a bakery and track your recipe creations in JIRA. The project is MyBakery, your epics are a custom issuetype called Recipe, and you want to find all of your recipes that do not contain Apples.

This will return all of your project specific recipes that include the word apples.

project = MyBakery AND issuetype = Recipe AND text ~ Apples

Save this as a filter, for this example, the filter name is 100.

 

In a new query, you can write...

filter != 100

This will return EVERYTHING in JIRA that is not in that filter. So to have it specific to your search you would rewrite the first half of your first search.

project = MyBakery AND issuetype = Recipe AND filter != 100

This will return all of the appropriate items that are not including the text Apples. 

 

Additionally, you can add multiple text options to mask out. If you had a customer who was allergic to Apples and Bananas, you could put in the first query 

project = MyBakery AND issuetype = Recipe AND text ~ "Apples OR Bananas"

 

Your JIRA version will dictate the correct syntax, see https://community.atlassian.com/t5/Answers-Developer-Questions/How-can-i-use-the-like-operator-with-the-List-of-values-in-Jira/qaq-p/545519 for reference.

This widget could not be displayed.

Do you want to match the exact text ? If not then you can use the contains (~) and in your case can be does not contain (!~) 

what is the JQL i have to user if i need exact text? Using ~ symbol it returns all issues that has the particular search string.  But i need only those issues that are exactly match to the search string.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

111 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you