How to remove Epic from list of epics? Edited

[Amitabh Ghoshal]

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.

[Ignacio Pulgar · Accepted solution]

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.

[Amitabh Ghoshal]

@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.

[Alexey Matveev]

You JQL query should be like this

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

[Amitabh Ghoshal]

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]

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.

[Amitabh Ghoshal]

I think I just solved it:

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

:-) 

[Alexey Matveev]

You know your requirements better :)