JQL for 'labels' not contain "delete"?

April Drake

This should be simple but the results don't match my expectations. 

here's the JQL <project = OE AND issuetype = "Epic/Feature" ORDER BY updated DESC>

...and here was my mod to filter out the labels contain "delete"

<project = OE AND issuetype = "Epic/Feature" AND labels !="delete" ORDER BY updated DESC>

but this does not yield the right results. I tried 'not in' but got the error "Operator 'not in' does not support the non-list value "delete" for field 'labels'. 

In SQL I could do a Not Contains but this doesn't seem to be supported. What am I missing?

Paul Alexander

You must include labels that are null in your query so you need something like this. Also, ref this page for supported operators and such.

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-labelsLabels

project = OE AND issuetype = "Epic/Feature" AND (labels !="delete" OR labels is EMPTY) ORDER BY updated