Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Romel January 11, 2022

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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 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
AUG Leaders

Atlassian Community Events