How to update a query every Monday ?

Question

I have this saved filter :

Category = xxxx AND status != Rejected AND updatedDate >="2018/06/04" AND updatedDate < "2018/06/11"

Using the above saved filter I can see the information in a pie chart . Every Monday I had to go the saved filter and change the date so that it reflects the previous weeks data. How can we resolve this ? I dont want to go back every week and change the date.. Any other way ?

PS : I am very new to JQL.

Dheeraj_fl3cyq · Answer

And this worked ! Thanks much..

Bastian Stehmann · Answer

Hi @Dheeraj and welcome to this community.

Maybe the startOfWeek and EndOfWeek Functions may help you, just have a look here for more information:

https://confluence.atlassian.com/jiracorecloud/advanced-searching-functions-reference-765593719.html