Show issues that contain only a single, specific value in a label

[kieran campbell]

Hi 

I'm trying to write a query based on the label field, where I want to exclude issues that contain a label but only when no other labels are specified.

E.g.

Issue 1, Label Values: x, y, z 

Issue 2, Label Values: x, 

Issue 3, Label Values: x, z 

Issue 4, Label Values: y, z 

So that only Issue 2 is excluded from the query.

Any suggestions?

[Sandesh Shetty · Accepted solution]

@kieran campbell 

Please look into this https://community.atlassian.com/t5/Jira-questions/Filter-issues-that-have-only-one-specific-label-and-no-other/qaq-p/670819 

[kieran campbell]

Thanks Sandesh

[Pramodh M · Accepted solution]

Hi @kieran campbell 

You can achieve this by combining 

labels = "label-1"

and

labels not in ("label-b", "label-c") JQL queries

Say if you want only issues with label "x"

The JQL query would go like this,

labels = "x" AND labels not in ("y", "z")

Please let me know if this solved your query.

Thanks,
Pramodh

[kieran campbell]

Thanks Pramodh, this answer gave me what I needed.

[ZC]

this is practical only if you have a limited number of labels ("y" & "z" in the given example).
when you have a lot of labels it is not practical.

anyone found another workaround for this?

we have 70+ labels, listing the 69 labels in the "not in" part is not doable.