How to filter time windows with JQL

[Gerardo Dalena]

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:

1. from Mon to Fri from 8:00 p.m. to 8:00 a.m.
2. from Sat to Sun anytime

These are the query that I have deployed, but I'm missing something in the syntax because the result I have are inconsistent:

1. (("Date and time TT Processing[Time stamp]" >= startOfDay()) and ("Date and time TT Processing[Time stamp]" <= startOfDay("+8h"))) OR (("Date and time TT Processing[Time stamp]" >= startOfDay("+20h")) and ("Date and time TT Processing[Time stamp]" <= startOfDay("+1d")))
2. ("Date and time TT Processing[Time stamp]" >= startOfWeek("+6d")) OR ("Date and time TT Processing[Time stamp]" < startOfWeek("+8d"))

Can someone please tell me whaat I'm doing wrong?

Thanks.

[Bill Sheboy · Accepted solution]

Hi @Gerardo Dalena 

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

[Gerardo Dalena]

Hello @Bill Sheboy 

that's a good food for thought, thanks!

Best regards,