Parent links closed with open epics | Trying to pull list of open epics only

[Denise DeCesare]

I am pulling in the parent initiatives that are closed which still have child issues which are not closed, I have this filter  - issueFunction in portfolioParentsOf("status != Done") AND status = Done

However, I need to also pull in the child issues which aren't closed so I can identity the specific issues that need to be closed. 

I don't know how to pull in the child issues that are still open. 

Thanks!

Denise D. 

[Venugopala naidu Neelam]

Hi @Denise DeCesare ,

Could you please tell me the version of Jira portfolio you are using ? 

[Denise DeCesare]

Hi, @Venugopala naidu Neelam , 

We are using Portfolio 2.26.0

Denise 

[Denise DeCesare]

@Venugopala naidu Neelam 

I don't need to use "portfolio" so to speak, I can also use a different script-runner query but I am trying to pull the parent links (Initiatives) which are closed plus the children which are not closed into one query. The children would be epics from our various teams. 

[Venugopala naidu Neelam]

Hi @Denise DeCesare ,

Please mention the project name in your filter;

issueFunction in portfolioChildrenOf("Project = "ABC" AND status != Done") AND status = Done

For Example:

Filter 1 (Get Epics linked to parent Initiatives) - issueFunction in portfolioChildrenOf("project = ABC")

Filter 2 (Get Stories linked to those Epics) - issueFunction in linkedIssuesOfAll ("Filter 1")

Filter 3 (Get Sub-tasks linked to those Stories) - issueFunction in subtasksOf("Filter 2")

Filter 4 (Final) - issueFunction in linkedIssuesOfAll ("Filter 1") OR issueFunction in subtasksOf("Filter 2") ORDER BY Rank ASC