How can I draw all parents & child-issues in a filter?

[Mirela Todorova]

Here is my challenge:

We use a single project to contain Initiatives and Programmes, no other issues types there. This project contains all Initiatives for all 3 squads that we have.

We want to create a Plan (Adv. Roadmap) for one of the squads, with a filter that displays only the programmes and initiatives, related to that Squad.

*The challenge is that we also want to be able to drill down to the Epics and stories, as well.

I know there is this JQL: "or issuekey in portfolioChildIssuesOf(FMPI-4) or issue in (FMPI-4)" but that requires me to list each of them manually and this is obviously not good, as it needs to be updated every time we create a new one. So is there something that I can use to say "give  me all Porgammes and initiatives from this project and all of their children (from other projects) ?

[Danut M _StonikByte_]

Hi @Mirela Todorova,

Our Great Gadgets plugin could be helpful here. It offers a Work Breakdown Structure (WBS) gadget that takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Initiatives > Epics > Stories, Tasks > Sub-tasks, exactly as you want.

All you have to do it to have a filter that returns the issues to be grouped and to configure the gadget to use this filter. Then, the magic will happen.   

Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.

I hope this helps. 

Thank you,

Danut 

[Charlotte Santos -Appfire-]

Hi @Mirela Todorova

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

Unfortunately, using vanilla JQL, 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 find programmes, initiatives and all their children:

issue in childrenOfIssuesInQueryRecursive("type in (programmes, initiatives)", 2) OR issue in parentsOfIssuesInQuery("type=Epic")

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

We’ll be happy to help you!

Best regards,

Charlotte