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.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL query to find all issues in "Ready for development" status last Saturday (endOfWeek)



I need to find all issues in "Ready for development" for each of the last weeks(Saturday). for e.g. end of last week, 2 weeks ago, 3 weeks ago.

here is a sample query I've written, need help to see if my understanding is correct

project = X AND issuetype in (Bug, Defect, Spike, Story, "Technical Chore") AND status was "Ready for Development" ON endOfWeek(-1) ORDER BY created DESC

I'm assuming the above query will give me all the issues which were in "Ready for Development" status last Saturday (by default, the last day is Saturday)

if correct, I'll keep changing the increment e.g. endOfWeek(-1), endOfWeek(-2), endOfWeek(-3), etc. to get results from past weeks.

Please let me know if my understanding is correct here.

Thanks in Advance.

1 answer

1 accepted

0 votes
Answer accepted
Pramodh M Community Leader Jan 11, 2022

Hi @Romel 

Yes the query you have written is correct!!

It will return the results based on the weeks parameter you specify till date



Suggest an answer

Log in or Sign up to answer

Atlassian Community Events