Forums

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

Query all Epics except those with resolution dates greater than 45 days

Ebony Burroughs
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!
September 1, 2021

I am trying to create a query that shows all epics in any status but include only closed epics resolved within the last 45 days. The current filter will give me all the epics and associated statuses, but the results for those closed are misleading. For example, the closed Epics show 31 but only 9 of those were closed within the last 45 days. 

Is there a way to exclude epics with older resolution dates via a JQL query?

1 answer

1 accepted

1 vote
Answer accepted
Leo
Community Champion
September 1, 2021

Hi @Ebony Burroughs

how about
project = xxx AND type = Epic AND (Resolved > -45d OR Status != Closed)

 

BR,

Leo

Ebony Burroughs
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!
September 1, 2021

That did it! Thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events