Filter to show the Epics with a specific Label along with its child issue and parent issues

[Pratip Kumar]

Hello,

I am trying to create a filter that will display Epics with a specific Label say 'Team X' along with its child issues and parent issues.

I am able to get the child issues but not the parent issues. I haven't been able to get the syntax right.

Looking for help!

Thank you!

Pratip Kumar

[Mikael Sandberg]

Hi @Pratip Kumar,

Welcome to Atlassian Community!

You would need an app that extends JQL in order to do that. I know Enhanced Search/Scriptrunner and JQL Tricks can do this, but there are other apps in the Marketplace that can do it too.

[Rahul_RVS]

Hi @Pratip Kumar 

Welcome to Atlassian Community !!

As mentioned by other members this would need a mktplace app.

If you fine with that, you can try out our add-on.

Issue Hierarchy Reports 

and generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

- Epic Hierarchy on Issue Screen

Disclaimer : I work for the vendor who built this app

[Hannes Obweger - JXL for Jira]

Hi @Pratip Kumar

just to add to Mikael's answer, another option may be to look into one of the more hierarchy-focused apps from the Atlassian Marketplace. These apps typically have their own, more powerful ways of sorting out and navigating through issue hierarchies.

I can only speak for the app that my team is working on - JXL for Jira - but in JXL, your use case would be easy to do:

• Create a new sheet with all your relevant epics (of label "Team X"), plus any potential parent issues, plus any potential child issues. Don't worry about the parent/child relationships; JXL will sort this out for you.
• In JXL, configure your issue hierarchy. This should be a matter of a few clicks.
• In JXL, hide any top-level issues without children, and any bottom-level issues without parents. That's just a click each.

The resulting set of issues will be what you're looking for, displayed in their issue hierarchy (I'm using the label "spectre" here just as an example):

You can now work on these issues directly in JXL (using Excel/Google Sheets-style inline-editing), trigger various actions in Jira, or export them for further processing.

As said before, there may be other apps in the Atlassian Marketplace that could help with that; if a Marketplace app is an option, perhaps try a few and see which one works best for you.

Any questions just let me know,

Best,

Hannes