JQL for 'labels' not contain "delete"?

April Drake February 23, 2017

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?

1 answer

10 votes
Paul Alexander
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 24, 2017

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
Modest Morina December 1, 2021

Thank you very much, worked for me.

Like # people like this

Suggest an answer

Log in or Sign up to answer