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.
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))
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event