Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Carlos
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
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_
Atlassian Partner
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