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")

[James Jones]

To search for the lack of a label, you have to include "OR labels is empty" in order to include issues that have no labels in your results

Example (to find open issues where one or both of 2 desired labels is missing): 

project = "xyz" AND (labels !=abc OR labels is empty) AND (labels !=def OR labels is empty) AND status != Done ORDER BY key ASC, issuetype ASC

[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.