Create a filter

Question

Hello everyone, I need to create a dynamic filter that will show me results from Monday to Friday but within a specific period of time, let's say from 8AM to 10 AM. I have tried this : (created >= startOfWeek("+1d") AND created <= endOfWeek("+1d")) AND (created >= startOfDay("+8h") AND created <= startOfDay("+10h")) But this shows me only the results for today and not also from yesterday between 8 and 10. Thank you!

Vlad Manolache_09penw · Answer

Hello Fazila,

Yes indeed, this is to tackle the total of issues created every week within a certain period of time.

Regards,

Vlad

Fazila Ashraf · Answer

Hi @Vlad Manolache

When you use startOfDay, it is always relative to current day and that is why it filters for today's issues.

I presume that this is for a use case on finding issue created in business/sla hours. In past, i tackled this with an automation that updates a label on the ticket if the ticket is created while SLA is not running. And then used the label to filter for issues that are in/not in the business hours. Hope this helps!