How to remove Epic from list of epics? Edited

What I'm looking for should be pretty straightforward; yet I cannot make it happen. My query:

type = Epic AND "Epic Link" != XXXXXX-XX

results in an empty list.

Variations I have tried are:

type = Epic AND "Epic Link" not in (XXXXXX-XX, YYYYYY-YY)

type = Epic AND component ~! XXX       . . . where XXX is a theme component I put in to exclude certain epics

Just in case someone is about to ask the obvious question - I do have epics. A search query 'type = Epic' does give a list of epics.


3 answers

1 accepted

0 vote

The most straight-forward JQL for excluding an epic from the filter would be:

type = Epic AND key not in (<epic issue key>)

Where <epic issue key> could be, in example XYZ-258.

Note that you could easily exclude more than one epic by adding their issue keys separated by commas, ie:

type = Epic AND key not in (XYZ-258, JRASERVER-57, JSD-22)

So, there's no need to flag the Epics with a component for filtering them out, which would only be better if the epics you wanted to filter out already had that component in common, while no other epics you wanted the filter to still return belonged to that component.

Hope it helps.

@Ignacio Pulgar - that is exactly the solution I was looking for - thanks you! That pulls me out of the rabbit hole of epic-link that I was stuck.

0 vote
Alexey Matveev Community Champion Jan 23, 2018

You JQL query should be like this

type = Epic OR "Epic Link" not in (XXXXXX-XX, YYYYYY-YY)

Hi Alexey, that works, but results in a list of issues that are not in those specific epics. So that means that the "Epic Link" will not work as epics don't have an "Epic Link".

Based on your answer, I will update my question.

Alexey Matveev Community Champion Jan 23, 2018

Epic Link is a field which stores a reference to an Epic. This field can not be set for Epics. That is why your query will never return any result.

I think I just solved it:

type = Epic AND (component is EMPTY OR component != XXX)


Alexey Matveev Community Champion Jan 23, 2018

You know your requirements better :)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,064 views 15 13
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you