Filter all non resolved Epics with only closed or resolved tasks in them

Carlos May 9, 2019

Hi I´m trying to filter all the epics in my project that are neither resolved nor closed, but all their tasks are closed or resolved. I came up with this JQL:

(issuetype=Epic and status != Resolved) and (issuetype=Epic and status != Closed) and
(issueFunction in linkedIssuesOf("status = Resolved", "has epic") or issueFunction in linkedIssuesOf("status = Closed", "has epic")) and not
(issueFunction in linkedIssuesOf("status != Resolved", "has epic") and issueFunction in linkedIssuesOf("status != Closed", "has epic"))

which almost does the trick. It returns all the epics with only closed or resolved tasks. The only problem is: it doesn´t return epics that only have both closed and resolved tasks.

Can anyone help me? Thanks.

 

1 answer

0 votes
Prem Chudzinski _extensi_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 22, 2019

try changing "status != Resolved" to "status not in (Resolved, Closed)" and similar for = operations

Suggest an answer

Log in or Sign up to answer