How to show issues linked to parent epics

[Karl Stone]

I have a company-managed project with a set of epics, and have created issues linked to those epics, then moved the child issues into different projects.  I'd like to create a filter that shows all the child issues linked to all the parent epics.  I was able to create this by listing all the parent epics individually, but if I add more epics I will have to modify the query each time.  Is there a way to do this with a wildcard or "show issues in all projects when parent epics are in project x"? 

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Karl Stone

welcome to the community!

As already suggested, this isn't natively supported in Jira. However if you're open to solutions from the Atlassian Marketplace, you'll find options there. E.g., your use case would be trivial to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. If you apply text filtering to your issues' parent field, and search for the project key that you're interested in, you should be able to get to your issues in just a couple of clicks:

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click. (I should add that JXL can do much more than that: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.)

Any questions just let me know,

Best,

Hannes

[Trudy Claspill · Accepted solution]

Hello @Karl Stone 

Welcome to the Atlassian community.

There is not a way to do that with native Jira functionality, unfortunately. It will require a third party app. Are you willing to consider a third party app?

The childrenOf() function from Adaptavist Enhanced Search would provide that functionality.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions#childrenof

It is possible to get that list through an Automation rule, and the results could be sent as an email, if that would satisfy your need.

[Karl Stone]

Thanks Trudy!  I'll look into ScriptRunner. 

[Charlotte Santos -Appfire- · Accepted solution]

Hi @Karl Stone 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all issues linked to epics from a specific project:

issue in linkedIssuesOfQuery("project = ABC AND type=Epic")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Amay Purohit_RVS · Accepted solution]

Hi @Karl Stone 

Welcome to the community !!

As an alternative, try out at an add-on we have developed for the same use case.

Issue Hierarchy 

The app shows your issues , their subtasks and the linked issues as well in a simple and easy to use tree view, with progress at each parent level. In the example below the hierarchy based on issues linked across different projects. You can also track progress at each parent level based on time tracking fields/story points/custom number fields/ or child issue statuses.

Disclaimer : I am part of the team which developed this app