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
4,364,976
Community Members
 
Community Events
168
Community Groups

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

Edited

Hello,

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

Thanks,

Pramodh

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events