Community
Products
Jira
Questions
JQL - Find issues whose status changed during a moving window perid

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

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

Advanced searching - Operators reference

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Many Thanks @Daniel Ebers and @Jack Nolddor _Sweet Bananas_ !!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Awesome! Thanks, Daniel.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Thanks, Daniel!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Thanks !! :)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase