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 filter by the Epic Link of parent

Edited

Hi,

i want to have a filter that gives me all issues with a specific epic link and all their sub-Tasks. Is there a possibility to filter by the parents epic link?

so a JQL query could look like this: "Epic Link" = epic OR parent.EpicLink = epic.

Or is there maybe another solution for this filter?

 

Thanks!

Philipp

4 answers

1 accepted

1 vote
Answer accepted
Jack Brickey Community Leader Jun 20, 2018

This is an often asked question. A bit of searching in the community will give you the answer.

OOTB - No 

Scriptrunner option - "Epic Link"=XX-###) OR issueFunction in subtasksOf("\"Epic Link\"=XX-###"

JQL Tricks has the ability too 

and other addons i suspect

Thanks Jack, is there no way in 'stock' Jira though? Our team is limited by corporate policy, so we can't get plugins without a mess of red tape and 18 pages of cost benefit analysis... Sigh

Like # people like this

Same here! 

Big company, red tape -> stock Jira solution please!

Jack Brickey Community Leader Jan 10, 2020

none that I have found

Hey @Jack Brickey could you please explain more how to use the Script Runner JQL?

An example it would be great.

Thank you

Jack Brickey Community Leader Apr 24, 2020

Unfortunately I cannot as I am not using the addon. However, there are quite a number of threads that discuss this in the Community so you can use search to locate. Also, the documentation is actually quite good as well.

No problem,

Thanks for the documentation URL.

We now have Advanced Roadmaps(formerly: Jira Portfolio) as part of migration from JIRA Server to JIRA Data Centre...Comes for free!!! It gives a hierarchical view of an Epic and it's children on a Gannt chart Plan. We've then created our own Master Epic Issue Type and made it the Parent of these Epics (rather than use an Epic as Parent) to render them in that hierarchy view nicely. We link them to equivalents in AHA! using the OOTB Integration and so far the data seems to be synching nicely and gives the long missing hierarchy view in one place in JIRA as AR allows for basing a plan off a Board and an assorted of field filters within to slice and dice your data as needed to show what's committed vs what's not. I haven't researched cost of this if not on JIRA DC but it's a decent option we got lucky on.

I found the 'parentepic' field. 

not sure if this applies to what you're doing but for me:

using kanban board with swimlanes based on queries

made a swimlane for each epic: "Epic Link" = <epic's issueid> OR parentEpic = <epic's issueid>

This results in all the stories in an epic AND all the subtasks of the stories in the epic displaying in one swimlane

That field works for me. Thanks a lot.

For me, too. Thanks!

Hi pals,

I've tried all the options suggested but non of them worked. So I've found the one that worked for me:


"Epic Link" = XXX-NNNN OR issueFunction in subtasksOf("Epic Link = 'XXX-NNNN'")


We have Jira 8.5 without any extra plugins.

Thanks !

It works with a slight change:

"Epic Link" = XXX-NNNN OR issueFunction in subtasksOf("'Epic Link' = 'XXX-NNNN'")
Like Josef Pavelec likes this

Actually, I found an out-of-the-box solution. I don't know if it's a recently added or overlooked functionality, but here you go: 

"Epic Link"=[epic] OR parent in childIssuesOf([epic])

Hi Alice, which version are you running?

On 7.8 this does not work. 'childIssuesOf' comes back with "Unable to find JQL function 'childIssuesOf(xyz)'"

Not sure if this is perhaps a custom function that has been added to your instance, or maybe it only comes with newer versions?

In Jira 8.5 there does not seem to be 'childIssuesOf'

It is hard to imagine that there is no native solution for such a basic function... Isn't there any Jira developer here to solve issues like this?

Hi @Mirko , unfortunately there isn't anything in the base Jira Server for this. It turns out that 'childIssuesOf' is a function provided by the ScriptRunner plugin. I was able to (after some time and effort) wrangle corporate red tape to get ScriptRunner added to our instance, and honestly it's pretty useful. But understandably frustrating that we need to pay for a plugin for this functionality.

Edit: Spelling

Thank you for the answer. It worked for our team!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

453 views 2 6
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