Mismatched status of initiatives

[Justin Peters]

Hello Everyone,

I'm trying to build a filter that looks for initiatives in a new or closed status with epics that are in progress. An example of this would be a new status initiative with an in progress epic.

This is the filter I created to solve it.

Issuetype = Initiative AND Status IN (Closed, "Under Refinement", "New") AND issueFunction in linkedIssuesOf("STATUS ='In Progress' AND ISSUETYPE = EPIC")

The problem I am having is that it is picking up on "associated epics" that are currently in progress. Is there any way to change or update the filter to not include associated epics? 

[Ste Wright]

Hi @Justin Peters 

Can I confirm you want to get as results...

• Initiatives which are in the Statuses Closed, Under Refinement, or New
• That have direct child Epics which are In Progress

...is this correct?

---

Have you tried this?

issuetype = Initiative AND status IN (New, Closed, "Under Refinement") AND issueFunction in portfolioParentsOf("issuetype = Epic and status = 'In Progress'")

Ste

[Tansu Akdeniz]

Hi @Justin Peters 

Welcome to the community.

What do you mean by "associated epics"?

Your query searches for linked issues. However, there is also a function called epicsOf. Please take a look this page.