Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to exclude parent issues in jql?

Hi I have a JQL filter:

project = "MARKETING 2021" and issuetype = Epic and status not in (done) and "Parent Link" IS NOT EMPTY order by Due asc

and I would like to add to it that the epics' parent initiative should not be included in PIN-973 theme. (We use themes, objectives and initiatives).

 

Can someone help me with that? :) 

2 answers

Hi @Lance Bennett yes I am using initiatives as epic parents. The thing is: I don't want to exclude 1 parent initiative but all initiative that are child issues of all objectives that are child issues of 1 theme. So basically I want to exclude 1 theme and not an initiative.

You could include another saved filter into your JQL. You might even need to reference two other filters due to your multiple levels of hierarchy. For example, create a saved filter showing the list of tickets you want to exclude.

project = "MARKETING 2021" AND issuetype = Epic AND status not in (done) AND "Parent Link" IS NOT EMPTY AND filter!=123456 order by Due asc

What issue type are you using the for the epic's parent? If you're hierarchy is Initiative > Epic > Story then you shouldn't see the Initiatives.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

585 views 21 25
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you