Global variable usage in filters
I have a global variable that extract Hour from the endTime field. If I use it in fieldsets everything looks fine it gets the right hour.
Problem comes when I try to use it in filter for example:
I want to find all events that happened after working hours like:
Hour_of_the_day in (18,19,20,21,22,23,0,1,2,3,4,5,6,7)
Hour_of_the_day >= 18
Hour_of_the_day =< 23
Hour_of_the_day >= 0
Hour_of_the_day =< 7
I have checked the Global variable and it says it is an integer. So where is the problem?
Re: Global variable usage in filters
I have the same issue with the GetHourOfDay variable.
The variable works when I for example set it to !=0 but when I try to use a range for example Between(0,6) the rule I use is not working.
I can put the same condition in a filter and create an active channel but not use in rule for some reason.
Did you come up with a solution?