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 votes

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 votes
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 Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

240 views 0 11
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot