How to update a query every Monday ?

[Dheeraj]

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.

[Bastian Stehmann]

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

[Dheeraj]

And this worked ! Thanks much..