nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Tracy Dobbs

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

Accepted answers

Dave Mathijs

Hi Tracy,

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

Thanks,

Dave

Jack Brickey

try this….

Project = abc and labels = string1 and labels = string2

Tracy Dobbs

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

All comments

Dave Mathijs

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

Jack Brickey

try this….

Project = abc and labels = string1 and labels = string2

Dave Mathijs

Jack has given you the correct answer below.

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

Tracy Dobbs

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!

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_lfef5u

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

atl-bobross