Hello,
I'm struggling with a JQL query to filter results in several time windows. I need to filter some issues outside business hours, so:
These are the query that I have deployed, but I'm missing something in the syntax because the result I have are inconsistent:
Can someone please tell me whaat I'm doing wrong?
Thanks.
Those functions you are using from advanced JQL are relative to the current day. They do not float as I believe you are expecting for any day. I do not believe that is possible with out-of-the-box Jira Cloud's JQL. There are marketplace scripting add-ons which could help.
For your weekly query, startOfWeek() is again relative to the current day, and weeks start on Sunday with 1. So your >=+6 includes Friday and your +8 is in the future. :^) You could check last week by using >= startOfWeek(-1d) to < startOfWeek(+1d)
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.