Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for multi-valued `labels` missing a particular value

Janet Swisher
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 30, 2024

I have seen that the way to query for a `labels` field that is missing a specific value is:

 

labels is EMPTY or labels not in ("x")

 

However, I have multiple label values that can be used, and this does not seem to work for that case. For example, if an issue can have any combination of 'label1`, 'label2`, and `label3`, I want to search for issues that are missing `label1`. Because there are actually many more than 3 possible labels, it isn't practical to test for all possible combinations. 

Any suggestions? 

1 answer

1 vote
John Price
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.
July 30, 2024

Hi Janet -

If you want to find issues missing "label1" that do have *some* labels, just do

labels is NOT EMPTY AND labels not in ("label1")

What's the goal? Maybe I can help more if I know more.  Let's say you now have 100 labels (label1 - label100). What are you trying to figure out?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events