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

[Karen Brasch]

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!

[Nic Brough -Adaptavist-]

The order by clause has to be the last in the query.

Label works the same way as other data like Project.  Try "Label not in (x, y, z)"

[Karen Brasch]

THANKS for quick response. I wrote this, but JIRA didn't like it:

project in (XYZ,ABS) AND issueType = "Security Defect" AND status != Closed ORDER BY priority DESC "Label not in (TUV)" 

[Jan-Peter Rusch]

As Nick wrote: Order by has to be the last in the query. Put AND label not in (TUV) Before the ORDER BY

[Karen Brasch]

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

[Nic Brough -Adaptavist-]

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

[Karen Brasch]

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