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

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

Suggest an answer

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

Atlassian Community Events