The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
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 Kumar Gangwar
Community Champion
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 () 

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events