How to create a dynamic filter between weeks and between a specific timeframe

Vlad Manolache_09penw

Hello everyone,

I need help in order to create a filter that will start on Monday and reset on next Monday, for example:

created >= startOfWeek("+1d") AND created <= endOfWeek ("+1d")

but I need for the filter to show me results from a specific timeframe. For example, from Monday to Sunday to show results between 8 AM and 11 AM.

 

Thank you!

BHUSHAN PATIL_fap6cn

Hi @Vlad Manolache  ,

Jira's JQL doesn't have a direct function to specify time ranges within a day. try following JQL which approximates the time range within the day based on timestamps.

The startOfDay("+8h") and startOfDay("+11h") are indicative and might not precisely represent 8 AM and 11 AM in all scenarios due to timezone differences or issues created at the exact start of that hour.

(created >= startOfWeek("+1d") AND created <= endOfWeek("+1d"))
AND (created >= startOfDay("+8h") AND created <= startOfDay("+11h"))

Adjust the time range and constraints based on your specific requirements and timezone considerations.

Regards,
Bhushan