Trying to create a filter to extract the Epics with all the child issues closed

[Pasquale Napolitano]

Dear All,

I'm trying to create a filter to extract the Epics with all the child issues closed.

E.g: if the epic has all stories/bugs/tasks/pre-delivery closed then it should be extracted by the filter; if at least one child is not closed yet then it should not be extracted.

Any suggestions for JQL functions or sub-query?

Thanks in advance and kind regards

Pasquale

[Marc - Devoteam]

Hi @Pasquale Napolitano 

Welcome to the community.

This question has been answered many times on the forum.

See: https://community.atlassian.com/forums/Jira-questions/Filter-with-all-child-issues/qaq-p/2999786

If you are using only native Jira functionality then you will have to create a filter like this with the explicit issue keys for the Epics you want to include:

issue in (<comma separated list of Epic issue keys) or

porfolioChildIssuesOf("<first Epic's issue key>") or

porfolioChildIssuesOf("<second Epic's issue key>") or

porfolioChildIssuesOf("<third Epic's issue key>") or ...

etc.

Another query that could work would be:

issue in (<comma separated list of Epic issue keys) or parent in (<comma separated list of Epic issue keys)

With some third party apps that extend the JQL capabilities it is possible to get the child issues of Epics based on a filter that gets the Epics.