How to pull children and grandchildren of multiple portfolios at once

[Daniel G_ Sinclair]

I have a list of about 50 portfolios. I am trying to use JQL and/or scriptrunner to pull the children and grandchildren. I don't want the linked issues, but the children...

I have a filter (39640) that provides the list of portfolios (it's manual by key)

1. The portfolioChildIssueOf() only takes one argument, not 50 ;)

2. When I attempt this in Scriptrunner, I only get the linked items - i need the children:
issueFunction in linkedIssuesOf(filter="39640")

3. When I attempt this in Scriptrunner, I get too many results (so none!)

Search parsing timed out. You probably have a subquery that returns too many issues.

issueFunction in linkedIssuesOfRecursive("filter="39640"")


4. This query gives me limited results and NOT all the children. but some of them

issueFunction in linkedIssuesOfRecursiveLimited("filter="39640"", 2, "is parent of") 

5. This query gives me NO results

issueFunction in linkedIssuesOfRecursiveLimited("filter="39640"", 2, "is child of") 

Thanks for any help.

[Crystelle S]

Clarification, are you using the Advanced Roadmaps/Portfolio tool (thus building the hierarchy via 'Parent Link')? If so, have you tried issueFunction in portfolioChildrenof()

Otherwise, have you tried "haslinks"? where you can specify the link type, referencing the portfolio filter?

[Sean Blezard]

That requires scriptrunner extensions. This works on server/data centre Jira. On cloud they seem have gotten rid of that function. I'm trying to find the alternative.