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

I have 3 labels in the query but i need only 2 out using JQL?

Mahesh_txhauc

Hello Atlassian Community Team,

I have the following use case, and I need some help.

Use Case:

We have the following Labels across 5 JIRA stories - Customer-Experience, UAT, Operations, FY26Q1, FY26Q2.

Story - 1: Customer-Experience, UAT, Operations, FY26Q1, FY26Q2.

Story - 2: Customer-Experience, UAT, Operations, FY26Q1.

Story - 3: Operations, FY26Q1, FY26Q2.

Story - 4: UAT, Operations, FY26Q1, FY26Q2.

Story - 5: Customer-Experience, UAT, Operations, FY26Q1, FY26Q2.

But I only need Customer-Experience and Operations to show without the other 3 labels being listed.

I tried following queries, But it does bring out all the results.

project = XXXXX AND issuetype = Story AND status = Done AND (labels IN (Customer-Experience, Operations) AND labels != ("FY26Q1","FY26Q2, "UAT"))
project = XXXXX AND issuetype = Bug, Story AND status = Done AND (labels IN (Customer-Experience, Operations) AND labels NOT IN (FY26Q1,FY26Q2, UAT))

Please help with the Query, if not please suggest what other options can be used in this case.

Thanks,

Mahesh

Accepted answers

All comments

Bill Sheboy

Hi @Mahesh -- Welcome to the Atlassian Community!

A JQL expression helps search for work items / issues meeting the criteria. It does not impact filtering the specific values of fields shown in the results.

What problem are you trying to solve by searching for work items containing those two label values but not show all label values? That is, "why do this?"

Knowing that may help the community to offer better suggestions.

Kind regards,
Bill

Mahesh_txhauc

Hello @Bill Sheboy

Thanks for the quick response.

I am trying to plot a Gadget (Pie Chart) against these 5 stories and I wanted to know how many the Count to show how many are part of Customer Experience and How many are part of Operations.

Thanks,

Mahesh

Bill Sheboy

Thanks for that information, and...

With the built-in dashboard pie chart gadget, there is no additional filtering to do that. Workarounds would be needed, such as:

Use separate gadgets which report one of the values at a time for the count (e.g., filter results gadget)
Use an additional label custom field, updated with automation rules, which can only contain those two values, and then report on that new field. This approach is brittle and would potentially consume too much automation execution count.
Investigate marketplace addon gadgets which have better filtering / reporting controls

Mahesh_txhauc

Use separate gadgets which report one of the values at a time for the count (e.g., filter results gadget) --- This is the Problem right Bill, I can't plot a report with individual result out. As with the Query it is bring out rest of the other labels in the filter.
Market gadgets are not allowed for us.
Use an additional label custom field - Thinking to Use Components and separate the values, Need to explore.

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