Page 1 of 1

No Date condition in Filter

Posted: Tue Nov 26, 2019 5:25 pm
by son_ds
Hi everyone!

I am creating a filter that sort out events that are more than 1 week old, and apparently on ZM's documentation, I should look for the Date element in the filter and set the value of -7.

But I do not see any "Date" or "Date/Time" element in the drop down list. All I have is Start Date or End Date, and input -1 or -7 does not give me any result. Is this feature removed and ZM doc has not been updated accordingly?

Re: No Date condition in Filter

Posted: Tue Dec 17, 2019 2:39 pm
by banzaay
I have the same problem, I'm trying to create a rule that delete all the messages older than 10 days.

How can I do that ?

Thanks

Re: No Date condition in Filter

Posted: Thu Dec 19, 2019 12:08 am
by iconnor
Use Start Date. Events have both a start and an end.

Re: No Date condition in Filter

Posted: Thu Dec 19, 2019 9:23 am
by banzaay
I have created a filter in this way (sorry for the image in italian):
Schermata del 2019-12-16 12-24-15.png
Schermata del 2019-12-16 12-24-15.png (33.04 KiB) Viewed 497 times
Start Date <= -10 days

But it is not working.

Re: No Date condition in Filter

Posted: Fri Dec 20, 2019 2:54 pm
by iconnor
Okay use Start Date / Time I know it works, I will go test Start Date.

Please note that Start Date / Time is actually faster, as it results in sql that looks like:

Starting < '2019-12-17 00:00:00'

whereas StartDate results in

date(Starting) < '2019-12-17' which means mysql has to perform a function on each Starting value and can't use indexes.