Filter that shows hierarchy

Question

How do I create a filter to show the Epic, each of the User Stories, and each of the Sub-Tasks under each User Story?  Example:

* Epic* User Story 1 * Sub-Tasks 1,2,3

* User Story 2* Sub-Tasks 4,5,6

I can show all but the Epic, but if I do show the Epic, the User Stories and Sub-Tasks are not in the hierarchy.

Rahul_RVS · Answer

Hi @Michael Szczepanski

Welcome to the community !!

As everyone suggested a mktplace app can help here. If you are fine to explore one, I can suggest our app

Issue Hierarchy

The app also allows you to view your project issue hierarchy in a tree view. You can view %complete progress at each parent level. It roll ups the time tracking fields, story point or numeric fields at each parent level.

Disclaimer : I am one of the app team member

Danut M _StonikByte_ · Answer

Hi @Michael Szczepanski,

Welcome to the Atlassian Community!

Try using a JQL filter like this:

parentEpic = DEMO-188

or

parentEpic IN (DEMO-188, DEMO-200, ...)  - if you have multiple epics.

This will return all the issues under the epic along with the epic itself.

But the JQL will not display the issues by their hierarchy; they will be displayed in a list.

To display the issues by their hierarchy you will need an app from Atlassian Marketplace.

In case you want to try an app, our Great Gadgets app for Confluence Cloud offers a Work Breakdown Structure (WBS)  macro that can display the issues by their hierarchy Epic > Stories > SubTasks along with their current status. It can also display initiatives on top of epics. All you have to do is to configured this macro with a filter/JQL that returns the epics and their child issues (as in my example above).

Danut.

Charlotte Santos -Appfire- · Answer

Hi @Michael Szczepanski

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 Epics, Stories and sub-tasks in the hierarchy:

issue in childrenOfIssuesInQueryRecursive("type=Epic") OR issue in parentsOfIssuesInQuery("type=Story")

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉