The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

how to set JQL filter to check it is over 5 days from last update date

Austin Lehdonvirta
Contributor
July 26, 2023

how to set JQL filter to check it is over 5 days from last update date.

I checked in our project and found there was parameter such as last updated. Since there is no parameter like the date of today, I could not set up JQL like today date-last updated >= 5

Is there anyone knows how to set up this filter? Thank you!

2 answers

2 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Tansu Akdeniz
Community Champion
July 26, 2023

Hi @Austin Lehdonvirta 

You can use the following to find issues that haven't been updated for 5 days.

  • updated <= -5d
1 vote
Answer accepted
Rilwan Ahmed
Community Champion
July 26, 2023

Hi @Austin Lehdonvirta ,

Please use JQL "updated <= -5d". This will list all tickets updated todays date - 5days.

Or you can also use "updated <= startOfDay(-5d)"

Austin Lehdonvirta
Contributor
July 26, 2023

thank you so much Rilwan!

Like • Rilwan Ahmed likes this
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events