How to filter by the Epic Link of parent

[Philipp Gresek]

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

[Jeff Lovington · Accepted solution]

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

[Viet Cao Hoai]

That field works for me. Thanks a lot.

[Bernd Degen]

For me, too. Thanks!

[Jaroslav Slavo Sumbal]

thanks :) now I don't have to update 25 subtasks one by one :) 

[archana bhatt]

This solution works for me.

My JQL looks like this:

project="XYZ" and "Epic link" in (e1,e2,e3)  or parent in (e1,e2,e3) 

Issue1: Status!=done doesn't work, it displays done items too.

I am trying to use this query in the "Filter results" gadget 

and adding fields such as 

<<Epic name>> <<Epic Status>> <Issue type>> <<Key>> <<Description>> <<status>>

Issue 2 : Everything displays perfectly except <<Epic name>> and <<Epic status>>

How do I display these 2 fields ?

[Marlene Kegel - codefortynine]

Hi @archana bhatt,

I am Marlene from codefortynine.

If you want to display the "Epic Name" of the parent issue, this should be able when adding the "Epic Link" field as column to your Filter Results gadget.

"Epic Status" is not available as far as I know.

If you are open to work with a Marketplace app, you could have a look at Dynamic Custom Fields for Jira. 

With our app you can created - as the name suggests - dynamic custom fields from existing issue data using Jira expressions.

We also offer a template for a "Parent Status" field, which updates automatically in the child issue, when the status of the parent issue is updated. So you don't need any technical background to be able to create that field. 

Once you've added the field to your issues, you can display it in your filter results gadget or use it for your issue filters.

[Jack Brickey · Accepted solution]

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

[Shaun Grose]

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

[Jeroen Vandeweghe]

Same here! 

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

[Jack Brickey]

none that I have found

[Pier Nicolo Pinna]

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]

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.

[Pier Nicolo Pinna]

No problem,

Thanks for the documentation URL.

[John OLeary]

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.

[vborodav]

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.

[rockynox]

Thanks !

It works with a slight change:

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

[Jira Beheer UU]

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])

[Shaun Grose]

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?

[Jira Beheer UU]

Aha, I found it. It's part of this release: 

https://confluence.atlassian.com/jiraportfolio/portfolio-for-jira-2-10-release-notes-940678731.html

[Mirko]

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?

[Shaun Grose]

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

[Felipe Cantagalli]

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