How do I write a filter so it returns only items that contain two specific Labels?

[Tracy Dobbs]

How do I write a filter so it returns only items that contain two specific Labels? 

Right now, I have my filter written and selected my two labels.  The results show me all Epics with either label on it.  I only want to see Epics that have both labels.  Seems simple, but I can't figure it out.

Thanks,

Tracy

[Tracy Dobbs · Accepted solution]

I figured it out!  project = EXBA AND issuetype = Epic AND labels in (ccc_health_assessment) AND labels in (2021_h1_planned) ORDER BY cf[10009] DESC, cf[20963] DESC, created DESC

[Jack Brickey]

That looks strangely familiar!

[Jack Brickey · Accepted solution]

try this….

Project = abc and labels = string1 and labels = string2

[Jack Brickey]

project = EXBA AND issuetype = Epic AND labels = ccc_health_assessment and labels = 2021_h1_planned ORDER BY cf[10009] DESC, cf[20963] DESC, created DESC

[Jean Evelette]

OK and how to "exclude" Epics / Stories having a dedicated label?  This doesn't work -> labels != toto or labels not in ("toto")

[Dave Mathijs · Accepted solution]

Hi Tracy,

Can you share the JQL of the filter you've written?

Thanks,

Dave

[Tracy Dobbs]

Hi Dave,

project = EXBA AND issuetype = Epic AND labels in (ccc_health_assessment, 2021_h1_planned) ORDER BY cf[10009] DESC, cf[20963] DESC, created DESC

[Dave Mathijs]

Jack has given you the correct answer below.