How do I do a not equals operator in the advanced search?

Hi, I've tried several different ways but can't figure it out. All I want to do is create a field where if the value in it does not equal "backlog" it shows on my kanban board. I've tried using the != and !~ operators but neither work properly with the text field I've created. Any idea how I do this?



1 answer

My only that that if this is a 'label' type field then you have to do 'not in (backlog)'. The values you put should work though. Can you give me the details of the field? Is it a text 255 field?

Thanks for responding Luther. I'm literally trying to do a pretty simple thing I thought. But I think I may have figured out the issue. I've been creating a text field where I can put a value in it and then try to do a does not equal operator to exclude all the other items that don't have that value. Does the != and !~ operators not find empty or null values? I think that's what my problem has been. I assumed that if I had a field called Phase and put in a value of backlog that if I did

Phase = backlog I'd get all the backlog items

Phase != backlog I get nothing. So does != not give any empty or null values for text fields?

Try using 'is EMPTY'. That would be the way to show issues that have null values in text fields.

But I don't want to show only the empty values. I want to basically exclude anything that has backlog for phase. Other stories may have launch or alpha. What I want to do is create a filter that will return everything where phase does not equal backlog. That includes other values AND nulls. Any ideas on how to do that?

Phase!= "backlog" OR Phase is empty

That worked. thanks!

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

281 views 0 12
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot