JQL to select issue with multiple labels based on 1 label

aaron May 17, 2023

I need a way to select issues that have one or more labels, if any of the labels = x.  For example, I could have one issue with labels of x,y,z and another with x,y and another with x,a and some with a,b, z.y. I just want to select the ones that have x in them. Normally, I would use contains (~), but apparently the labels field doesn't support ~.  

1 answer

1 accepted

1 vote
Answer accepted
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 17, 2023

Hi @aaron

welcome to the community.

Maybe I'm missing something but wouldn't 

labels in ("x")

give you that?

Best,

- H

aaron May 18, 2023

You are correct.  

For some reason, I was thinking of "IN" in terms of SQL where the in is a list of values to select, not to be selected. so in jql, "IN"= SQL "Like" without the wildcards.

Suggest an answer

Log in or Sign up to answer