How to loop through a list of issue keys one by one in for Portfoliochildissuesof

[Matt_Rochman]

Hi All

I am wanting to do a simple field edit on every work item at every level of the hierarchy below a number of parent issues in one automation. 

With the JQL:

(parent IN portfolioChildIssuesOf("ABC-123")

This brings up all issues in the hierarchy below ABC-123, which is great! The main limitation of this is you can only run the query with one issue key at a time. 

In our setup, we have a small number of parent issues that I would like to run this automation on. Based on advice and info from other posts, I was able to use 

(parent IN portfolioChildIssuesOf("{{lookupIssues}}")

and this give the correct result, but because there were two issues, the automation ultimately failed because this won't work due to two issue keys:

(parent IN portfolioChildIssuesOf("ABC-123, ABC-124")

So ultimately I need to it to loop through the issues keys so it will update all child issues under ABC-123 and all child issues under ABC-124. 

Based on a few examples, I built this so far but it does not work:

The advanced branching rule is

Can anyone give me some direction on the right path to get the outcome I'm after?

Also what should the JQL on the scheduler be set to given this automation will be updating many work types in many projects in jira?

Thanks

[Trudy Claspill]

Hello @Matt_Rochman 

Welcome to the Atlassian community.

Are you using a JQL in your trigger?

What I would try is adding a JQL to the trigger to select the issues that you would use as the input for the portfoliochildrenof() function.

Then in the lookupIssues() action plug in your portfoliochildrenof() JQL statement with {{issue.key}} as the parameter.

Then set your branch to iterate over the results of the lookup.

The rule actions will be run for each issue returned by the trigger JQL. So the lookup will run for each of those issues. And the branching will be run for the results of each lookup.

I'm not where I can test this, but theoretically it should work.