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; } } }

Filter Query to exclude issues with a particular label

Franziska Mast

Hi there,

I am using a filter for a board (software project) to display issues. Now I would like to filter the issues in that board to exclude all issues that have a particular label called "Hardware" and "Innovation" - the result should be that I will see all issues except for those that have the label "Hardware" and/or "Innovation"

So in my example I have 20 issues, 11 of the issues use label "Hardware", 3 use "Innovation Management". In my board I want to see only those issues that use either Hardware nor Innovation

I tried several times, e.g. with labels !=Hardware or labels not in (Hardware), however the result was not what I expected

Can anyone advice please?

Thanks a lot!

Accepted answers

Mohamed Benziane

Hi,

Can you try

labels not in (hardware, innovation)

Trudy P Claspill

Hello @Franziska Mast

Welcome to the Atlassian community!

How exactly are the results not what you expected?

Are there issues missing that you think should be included? Why do you think they should be included?

Are there issues present that you think should be excluded? Why do you think they should be excluded?

All comments

Mohamed Benziane

Hi,

Can you try

labels not in (hardware, innovation)

Trudy P Claspill

Hello @Franziska Mast

Welcome to the Atlassian community!

How exactly are the results not what you expected?

Are there issues missing that you think should be included? Why do you think they should be included?

Are there issues present that you think should be excluded? Why do you think they should be excluded?

Franziska Mast

Thanks for replying.

I have in total 795 issues in my list. 257 of those issues (issue type user story, sub-taks, epic) use the label "Hardware" in the field "Labels".

However, when I want to exclude those 257 issues that use label "Hardware" from the filter the result only shows 96 issues. I would expect that the list shows 538 issues (795-257).

I am using the following filter: Project = "xx" AND labels not in (Hardware) order by created DESC / Project = "xx" AND labels != Hardware order by created DESC

Trudy P Claspill

Do the missing issues have any label value at all?

When you have a criteria to check the value of a multi-select field like Labels, the criteria can be evaluated only for instances of that field that actually contain a value. Jira can't compare the value "Hardware" to a field that contains no value.

If you want to include the issues that have no value in Labels then your criteria needs to be one of these:

Project = "xx" AND (labels not in (Hardware) or labels is empty) order by created DESC

Project = "xx" AND (labels != Hardware or labels is empty)

Franziska Mast

The 538 issues that I would expect to see as a result have either another label or none.

If I try "Project = "xx" AND (labels not in (Hardware) or labels is empty)" I get even more issues (1000+). Jira then also includes issues from other projects, event though I have specified the Project = "xx" in the filter.

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