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

Filtering out using labels

Kaushal Kumar Singh_snaiha

Hi Community,

I am trying to create a filter where I want to filter out work items with label having "Engineering". With the below query I am getting 0 results, but I should be getting 5 counts.

What is going wrong here?

project = ABC
AND type IN (Feature, Initiative, "New Feature")
AND statuscategory IN ("In Progress", New)
AND labels != Engineering
ORDER BY Rank ASC

Accepted answers

Gor Greyan

Hi @Kaushal Kumar Singh

Thanks for the question.

If you want to find tickets that have the label "Engineering", in your provided JQL, you put !=, which means you exclude those ones.
I think the following one will work, if you want all tickets, with the mentioned label.

project = ABC
AND issuetype IN (Feature, Initiative, "New Feature")
AND (statusCategory = "In Progress" OR status = "New")
AND (labels IN (engineering))
ORDER BY Rank ASC

If you want tickets that don't contain "the Engineering" label, you can use this one.
project = ABC
AND issuetype IN (Feature, Initiative, "New Feature")
AND (statusCategory = "In Progress" OR status = "New")
AND (labels IS EMPTY OR labels NOT IN (engineering))
ORDER BY Rank ASC

Let me know if this works for you.

All comments

Hari Krishna

Hi @Kaushal Kumar Singh ,

The issue occurs because labels is a multi-value field in Jira, and using the != operator doesn’t work as expected for such fields. The condition labels != Engineering may return zero results since Jira doesn’t handle multi-select fields this way. To correctly exclude issues that have the label Engineering, you should use the NOT IN operator instead. The correct query is:

project = ABC
AND type IN (Feature, Initiative, "New Feature")
AND statusCategory IN ("In Progress", New)
AND labels NOT IN (Engineering)
ORDER BY Rank ASC

This query properly filters out issues that contain the Engineering label while including all others. If you still get no results, double-check for label spelling or case differences (e.g., engineering vs Engineering).

Kaushal Kumar Singh_snaiha

Tried this, but still getting 0 count.

Gor Greyan

Kaushal Kumar Singh_snaiha

Thanks @Gor Greyan - The second one worked as I wanted to exclude the label.

AND (labels IS EMPTY OR labels NOT IN (engineering))

Gor Greyan

Dear @Kaushal Kumar Singh

Glad that it helps.

Have a nice day!

Lukas Maczejka _Appfire_

Hi @Kaushal Kumar Singh ,

Glad the pure JQL solution provided by @Gor Greyan works for you.

If you want a more visual approach, and if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a long list of further features, including labels support with powerful filtering options. This is what it looks like in action:

This is really just one of a virtually endless number of possible views and reports; you have full control over which data you want to show and highlight.

Any questions just let me know,

Best,

Lukas

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud