Need Help with JQL Query "Not in = label x"

Question

I'm writing a JQL query to give me status on a list of projects by key, but to exclude some labels.

The first part works:

Project in (XYZ, ABC)AND issueType = "Defect" AND status != Closed ORDER BY priority DESC.

But I also need it to exclude some labels. e.g. Not in label = TUV

I tried putting it in (), but that didn't work.

Project in (XYZ, ABC)AND issueType = "Defect" AND status != Closed ORDER BY priority DESC (not in label = TUV)

Thank you!

Karen Brasch · Answer

THAT WORKED! You are my hero. Thank you. :-) !

Nic Brough -Adaptavist- · Answer

Ok, have a close look at what you've got it called in your system - it's labelS by default.

Karen Brasch · Answer

That makes sense. It is saying "field label does not exist or you do not have permission to view it." Hmmm.