Recursive filter to find all issues related to a Program

[Jeanne Howe]

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_]

Hi Jeane,

Thank you for your question.

I can confirm that ScriptRunner for Jira Cloud does not provide a JQL function to support the Parent Link field out of the box as the API to provide this function does not exist in the Jira Cloud as it does in Jira Server. 

However, you may be able to return issues linked recursively using the linkedIssuesOfRecursive() JQL function which the plugin provides and is documented here.

You can see a more comprehensive list of the differences between the cloud and server versions of ScriptRunner inside of the documentation page located here. 

If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.

Regards,

Kristian

[Lewis Cook]

Hi Kristian,

 I've got the same problem and the linked issues option doesn't help due to the portfolio "Parent Link" not being a traditional Jira "link type" and therefore there is no option to use it as the link type.

IssueFieldMatch seems like it could fit the bill if there is some way to insert the array of Initiative keys for it compare to. I've tried a few ways and struggled to see a way to get it working.

Any advice?

Thanks

Lewis

[Jeanne Howe]

Hi Lewis,

I ended up submitting a support request for this scenario. After going round-and-round fro days, Atlassian finally admitted there is no way, in Jira Cloud or in Portfolio for JIra Cloud, to create a recursive query from Program down through the hierarchy. Even within Portfolio, you would have to "hard-code" the Program and Initiative tickets. 

Not sure how you call something portfolio management if you can't even query the portfolio for reporting/metrics on work in progress. Even in the on-prem version of Jira ad Portfolio you need the Scriptrunner plugin to get these reports. Portfolio does not support it. 

Jeanne

[Kristian Walker _Adaptavist_]

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

[Lewis Cook]

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_]

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