Forums

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

JQL to display stories transitioned over last 7 days?

Troy
Contributor
May 30, 2023

Hello, hope everyone doing well.

so basically I am trying to craft a JQL that will show me all the user stories which were moved from 'Ready for Dev' into 'In Dev' over last 7 days.

Here is my JQL

project = ABC AND issuetype = Story AND status changed FROM "Ready for Development" to "In Dev" AFTER startOfMonth()

How can I modify the above JQL to show me last 7 days data alone? Thanks!

1 answer

1 accepted

1 vote
Answer accepted
Alex Koxaras _Relational_
Community Champion
May 30, 2023

Hi @Troy 

Why don't you use AFTER startOfDay(-7) instead of startOfMonth()?

Troy
Contributor
May 30, 2023

That did the job :) thanks Alex.

Suggest an answer

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

Atlassian Community Events