JQL filter for Portfolio Epic and its children epic(s) and issues in children epic(s)

[Sudhir]

Hi All,

I would like to have JQL filter, where I wanted to get children epic(s) and issues from children epics from the Portfolio Epic. The following pictorial representation:

---

1. PORTFOLIO EPIC
   1. EPIC1
      1. Issues/stories
   2. EPIC2
      1. Issues/Stories
   3. EPIC3:
      1. Issues/Stories

Attempted JQL: issuekey in childIssuesOf("PE-1394") and type = epic AND "Scrum Team" in ('TEAM1', 'TEAM2')

This only gives EPIC1, EPIC2 and EPIC3. But, I also want issues/stories of the EPIC1, EPIC2 and EPIC3.

Any help is highly appreciated! Thanks in advance!

[Sudhir · Accepted solution]

This gives Epics names and its children and ignoring type = epic. Following JQL worked for me. Thanks everyone for your insights and inputs

issuekey in childIssuesOf("PE-1394") AND "Scrum Team" in ('TEAM1', 'TEAM2') AND type != epic

[Kian Stack Mumo Systems]

Try this:

issuekey in portfolioChildIssuesOf("PE-1394") and type = epic AND "Scrum Team" in ('TEAM1', 'TEAM2')

[Sudhir]

Unfortunately, I tried, it throws error "Unable to find JQL function 'portfolioChildIssuesOf(PE-1394)'."

[Kian Stack Mumo Systems]

You need to put your issue key in quotes.

[Sudhir]

Same issue for the following JQLs

issuekey in portfolioChildIssuesOf('PE-1394') and type = epic

issuekey in portfolioChildIssuesOf("PE-1394") and type = epic

[Laurie Sciutti]

Hi @Sudhir ~ Are you using the Parent Link field to link your Epics to your "Portfolio Epic"?

[Sudhir]

Yes! Portfolio Epic--Child Issues

[Danut M _StonikByte_]

Hi @Sudhir,

An easier way might be to use the Work Breakdown Structure (WBS) Gadget offered by our Great Gadgets app.

This gadget displays the issues from a filter by their hierarchy in form of Initiatives (Portfolio Epic) > Epics > Tasks, Stories > Subtasks along with their status.

This way you can get the pictorial presentation, exactly as you want. 

All you have to do is to create a Jira filter that includes all the issues to be grouped, and then to configure the gadget to use that filter.

Please note that this app offers many other gadgets that you will find useful. See the articles from our blog, to make an idea.

I hope this helps. If you need any help with the configuration, please don't hesitate to contact us at support@stonikbyte.com. 

Danut. 

[Sudhir]

Thank you Danut, unfortunately, my org doesnt allow third part apps.