JQL and multiple OR labels

[Danny Brothers]

I have a simple query that I want to use in a Kanban board sub-filter. I want to exclude any tickets that have either of these labels: Hold or Ongoing. Here's what I have so far, but it's not working (tickets with either label show up). 

(type = "My Department") AND (labels != hold OR labels != ongoing)

I've also unsuccessfully tried:

(type = "My Department") AND ((labels != hold) OR (labels != ongoing))

I should note that the first query with only (labels != hold OR labels is EMPTY) does work. I think I need to keep that EMPTY statement too. 

[Radek Dostál · Accepted solution]

If I'm understanding this then this should be it:

I would add that you may be misunderstanding what 'OR' does -- it's one or the other. So when you do labels != hold OR labels != ongoing, they both cancel each other out.

If I do 'not in()' below, then this is basically "does not contain any of these labels listed":

issuetype = "My Department" AND (labels IS EMPTY OR labels NOT IN (hold, ongoing))

[Danny Brothers]

You're a king! Do you have any idea how long I suffered with this? Thank you so much!!! (it worked!). Yes, I totally misunderstood the OR function. 

[Kagithala Babu Anvesh]

Hi @Danny Brothers ,

Try this once

Type = my department and labels not in (Hold,Ongoing)

[Danny Brothers]

That almost got it but I needed the Is Empty in there as well. Thank you so much!