JQL - Get Initiatives, Epic and Tasks

[Melissa C]

Hello I'm looking for a little guidance.

This is the requirement for the JQL - Get all Initiatives with Fix Version Q1 and Show all of the Epics that contain "Open Question" in the summary, and show all the Tasks (of the Epic)

Should this be a filter within in a filter.

I was thinking of using the filter = project = PP AND issuetype = Initiative AND fixVersion = "Q1"

And then filtering the filter but not sure how to do that.

Help!

[Joseph Chung Yin]

@Melissa C -

Unfortunately - out of the box you can use the following JQL syntax - porfolioChildIssuesOf() function where you will have to provide your initiative issue key.

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/#Child-issues

Example - porfolioChildIssuesOf() function

• To get all child issues below INIT-001 and not just the child issues at the epic hierarchy level:

  issuekey in portfolioChildIssuesOf("INIT-001")

Hope this helps.

Best, Joseph Chung Yin

[Melissa C]

Thanks @Joseph Chung Yin 

We have are not on cloud.  You don't think it's possible with multiple filters?

issuekey in childIssuesOf("XX-1230"), could I use this with the jql inside the parameters ?

[Joseph Chung Yin]

@Melissa C 

Regardless Cloud or Server env, you cannot use jql inside the parameters of the out of the box JQL function unfortunately.

However, if you are in the Server env, then you can take a look at Scriptrunner for Jira (DC version only) third party add-on for their enhanced JQL functions where you can use to achieve your need.

Sorry.

Best, Joseph