Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes
Pramodh M Community Leader Jan 11, 2022

Hi @Ram 

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
Community showcase
Published in Atlassian Access

Atlassian Access Demo Q&A Recap

Hi Community! Thank you to all who joined our ongoing monthly Atlassian Access demo! We have an engaging group of attendees who asked many great questions. I’ll share a recap of frequently ask...

458 views 1 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you