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: * PORTFOLIO EPIC* EPIC1* Issues/stories * EPIC2* Issues/Stories * EPIC3:* 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!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Sudhir_ifv9dd

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:

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!

Accepted answers

Sudhir_ifv9dd

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

All comments

Laurie Sciutti

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

Kian Stack Mumo Systems

Try this:

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

Sudhir_ifv9dd

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_ifv9dd

Yes! Portfolio Epic--Child Issues

Sudhir_ifv9dd

Same issue for the following JQLs

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

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

Sudhir_ifv9dd

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

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_ifv9dd

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud