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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

JQL Query to exclude certain Epics

Good day 

We have introduced an initiative level and now we would liek to pull that specific initiative number bu exclude some epics that are linked a childhran.

The following is not workign for us

Hi, I would like to use the following operator "!=" or "not in" for my jquery to exclude Epics that are linked to a specific "initiative"

 

regards 

1 answer

0 votes
Jack Community Leader Dec 03, 2020

Can you provide your exact JQL?

I would think you could use the following.

...AND issuekey not in (a,b,c) or “epic link” not in (a,b,c) 

The first part covers the actual epic issue keys and the second covers the issues that are part of those Epics. 

Thank you Jack , I am awaiting the users exact JQL.

So they are trying to exclude Epics that are part of an Initiative. The Initiative is the parent of the epic and used the field Parent link that came with Advanced Roadmaps.

Jack Community Leader Dec 03, 2020

Understand, I don’t use initiatives so things certainly may be different here but I can’t help but hope it is achievable. I have access to a premium test system so may try to play with it later today. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS

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