Forums

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

JQL - Find issues whose status changed during a moving window perid

Areej Khaddaj
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!
February 13, 2020

I want to retrieve all issues that had their status changed from X to Y during the "past 30 days". I don't want to use a specific date nor startOf... I want it to be a moving window, i.e. similar to >-1m

1 answer

1 accepted

3 votes
Answer accepted
Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2020

Please try the following JQL query in advanced mode:


status changed FROM "In Progress" TO "Resolved" AFTER -30d

A specific date is not in place in this example - as well as a startOf function is also not used.

Cheers,
Daniel

Jack Nolddor _Sweet Bananas_
Atlassian Partner
February 13, 2020

As an addition, here you have the complete documentation for CHANGED operator:

 


Regards

Like • 2 people like this
Areej Khaddaj
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!
February 13, 2020
Prasad Kawadkar June 14, 2022

Awesome! Thanks, Daniel.

carly_noreen June 15, 2022

Thanks, Daniel!

Eduardo Martins
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!
July 7, 2022

Thanks !! :)

Suggest an answer

Log in or Sign up to answer