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.

Get started Tell me more

Atlassian Community about banner

4,296,376

Community Members

Community Events

165

Community Groups

Community
Products
Jira
Jira Software
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

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS