Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How can I see epics older than 90 days and still open

I've created this query which shows me all open epics that are 90 days or older. However it still includes epics from september, august, july.. today is october 1st. I want to exclude anything created within the last 90 days I just want to see what's still open from 91 days and on. 

issuetype = Epic AND createdDate >= 90 AND status not in (accepted, rejected) ORDER BY created DESC

I also tried this: 

created >= startOfDay(-90d) AND issuetype = Epic AND resolution = Unresolved ORDER BY created DESC

However it literally just gives me anything created within the last 90 days not older than 90 days

1 answer

1 accepted

2 votes
Answer accepted

Nevermind figured it out using the two queries above and combining them

 issuetype = Epic AND createdDate >= 90 AND status not in (accepted, rejected) AND created < startOfDay(-90d) ORDER BY created DESC

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 01, 2022

Hello @GrapeApe 

There is a problem with your query.

"createdDate >= 90" is not really meaningful. It is trying to compare a date (createdDate) to the value 90. I'm not entirely sure what is happening behind the scenes, but that is not evaluating the time passage since the creation of the issue in the way you want.

So, looking at your query you need to eliminate the AND createdDate >= 90 portion of the query.


Also, if you want to find issues that were created more than 90 days ago you need to use < (less than) rather than > (greater than).

Let's say you want to find issues more than 3 days old.

-3d = 9/27/2022

created Date = 9/26/2022

9/26/2022 < 9/27/2022  TRUE

createdDate <= -3d  TRUE

created Date = 9/30/2022

9/30/2022 <= 9/27/2022  FALSE

If you use createDate > value then you are asking for issues where Created Date is newer than value.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events