Recursive filter to find all issues related to a Program

Question

We are JIRA cloud using Portfolio for JIRA. The hierarchy looks like this:

Program

Initiative

Epic

Story

The link between Story and Epic is the Epic Link

The link between Epic and Initiative is the Parent Link (originating from Portfolio)

The link between Initiative and Program is the Parent Link (originating from Portfolio)

I am able to create JQL to find all of the Initiatives linked to the Program via the Parent Link.

I would now like to take the output of this JQL and use it to find all of the Epics linked to the Initiatives via the Parent Link. (I do not want to "hard-code" the Initiative "keys" as new Initiatives can be added at any time)
Once I have that, I would like to drill down again to the Stories within the Epics via the Epic Link.

I know I can do this on JIRA Server/Data Center using ScriptRunner.

Is there anyway to do this in JIRA Cloud? Will ScriptRunner for JIRA Cloud support the Parent Link field from Portfolio for JIRA? Is there another plugin that will support nested JQL?

Kristian Walker _Adaptavist_ · Answer

Hi Lewis,

I can confirm we do not have any plans to do this and this is due to the fact Atlassian do not provide any API's to access the parent link field which means ScriptRunner could not implement this workaround.

Regards,

Kristian

Lewis Cook_vntdgk · Answer

Hi Kristian,

Thanks for confirming, its certainly a shame as I've been used to using Portfolio and Scritprunner on a server instance and it does make filtering and reporting options easier.

I'm assuming it's a fruitless question asking if/when Atlassian may be intending to extend the cloud API?

However are you aware of the possibility or intention at Adaptavist to make scriptrunner able to use an array of keys from a referred filter? It seems like a reasonable work around as well as some useful functionality, I may have missed it but wasn't able to get something like below working.

"parent link" in (Filter = "[Filter for Top Level Portfolio Hierarchy]")

Thanks
Lewis

Kristian Walker _Adaptavist_ · Answer

Hi Lewis,

I can confirm that unfortunately scriptRunner for Jira Cloud does not provide any JQL Functions to search for portfolio links as Atlassian does not provide the API's for this and this means that if the does not allow you to create the search you require then it will not be possible to search the hierarchy you require with scriptRunner for Jira Cloud.

Regards,

Kristian