My issue Hierarchy is Project Initiative - Epic - Story. I am looking for a query which finds all Project Initiatives which are not in " Completed" status.l but all the underlying Epics are in "Closed" status. I currently have the query which finds Project Initiatives which are not in "completed" status and has atleast one Epic in "closed" status.
Project= ABC and issuetype = Project Initiative and Status not in (Cancelled, Complete) and issuefunction in PortfolioParentsof ("issuetype=Epic and status =Closed")