JQL - Advanced Roadmaps - portfoliochildIssuesOf with multiple initiatives

Question

I am trying to use JQL to find all child issues (epics and stories) of a multiple initiatives.

Per the guidance here I should be able to use portfoliochildIssuesOf with an the IN operator but this doesn't work.

https://confluence.atlassian.com/advancedroadmapscloud/searching-for-issues-using-advanced-roadmaps-details-998651411.html

project = SSP AND issuetype in (Bug, Spike, Story, "Support - Task", Task) AND issuekey in portfoliochildIssuesOf in ("SSP-2198", "SSP-2359", SSP-2374, SSP-2370) ORDER BY Rank ASC

Alternative

I could do something like the below but this seems pretty ugly

issuekey in portfoliochildIssuesOf(SSP-2198) OR issuekey in portfoliochildIssuesOf(SSP-2359) OR issuekey in portfoliochildIssuesOf(SSP-2374) OR issuekey in portfoliochildIssuesOf(SSP-2370)

Background

* Jira cloud user with Advanced Roadmaps
* Multi-level hierarchy setup (Programme>Workstream>Feature/Initiative>Epic>Story/Task/etc
* Want to use these queries at each of the higher levels

Rafi Hagopian · Answer

Old thread I stumbled on while looking for something else, but that syntax doesn't make sense. You could do something like

project = SSP AND issuetype in (Bug, Spike, Story, "Support - Task", Task) AND issuekey in (portfoliochildIssuesOf("SSP-2198"), portfoliochildIssuesOf("SSP-2359"), portfoliochildIssuesOf(SSP-2374), portfoliochildIssuesOf(SSP-2370)) ORDER BY Rank ASC

Manish Arya_g0wtdr · Answer

Alternate solution you mentioned is also giving same error. Do we have solution for this? How can we get child issues of multiple epics or initiatives  in one go?

Trudy P Claspill · Answer

Hello @Kieran

I think you are asking about the same thing mentioned in this post from 2020

https://community.atlassian.com/t5/Jira-Software-questions/JQL-for-all-issues-linked-to-all-initiatives-in-a-project/qaq-p/1428045

According to that, at that time, you would need an app to extend the search functionality of JIRA.

I don't use the Roadmaps feature, so somebody with more experience might know more.