JQL: Is there something like IN, but filtering for all tokens in a list (AND instead of OR)?

Question

status IN ("To Do", "In Progress", "Closed")

is the same as

status = "To Do" OR status = "In Progress" OR status = "Closed"

I'm looking for something being the same as

labels = "cats" AND labels = "dogs" AND labels ="pets"

Is there anything like this?

Kristján Geir Mathiesen · Accepted Answer

Hi @Frank Reiter and welcome to the Community.

I think you will have to do:

labels = "cats" OR labels = "dogs" OR labels ="pets"

Also remember that if you want to see issues with nothing in the the Labels field, to include:

OR labels is empty

HTH,
KGM

Nic Brough -Adaptavist- · Accepted Answer

Welcome to the Atlassian Community!

There's no such thing as "in" with "and".  It's logical nonsense because there's no way to explain it to the system you want to ask it of.  The closest you could get is "has all of these attributes", but no-one usually bothers to implement that because you can do it quite clearly with "x = y and x = z", and not a lot of people have a use for it.

Felipe Pazetto · Accepted Answer

Like @Nic Brough -Adaptavist- said, it's unlogical to use a condition that is EQUAL and have AND to the same column/field. Even in SQL, this is wrong to use:

name = 'John' and name = 'Mary' and name = 'Susan'

The correct way is to use:

name in ('John','Mary','Susan')

I use this filters in my JIRA and I hope this can help you:

assignee in (5f53a61573a268004d29589b,6082d8f07495ff006a31c050) AND NOT (status = closed OR status = resolved OR status = Canceled) ORDER BY updatedDate DESC