Create a filter

[Vlad Manolache]

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!

[Fazila Ashraf]

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!

[Vlad Manolache]

Hello Fazila,

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

Regards,

Vlad