Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Quick filter JQL query

Lizzie Jack
Contributor
September 26, 2023

Hi, 

I would like to create a quick filter that shows me all backlog tickets across two projects on one board that excludes tickets with specific labels attached.

So far, I have got...

(project = "project 1" OR project = "project 2") AND labels not in (DevOps, devOps, data, DataEngineering)

The above eliminates all tickets from project 2 instead of including the ones that do not have the specified labels.

 

Any ideas would be greatly appreciated

2 answers

1 accepted

1 vote
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 26, 2023

Hi @Lizzie Jack , try adding the "empty" consideration.

(project = "project 1" OR project = "project 2") AND (labels not in (DevOps, devOps, data, DataEngineering) or labels is empty

Lizzie Jack
Contributor
September 26, 2023

this worked... I think!

Thank you

Like Jack Brickey likes this
0 votes
Manoj Gangwar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 26, 2023

Hi @Lizzie Jack , 

What is your board filter query? Is it includes the project 1 in if not then include it on the main board filter query then you can simply try below

Project in ( 'project1', 'project2') and labels not in (xyz, abc) 

Or directly use labels not in () 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Upcoming Jira Events