No Date condition in Filter

Forum for questions and support relating to the 1.32.x releases only.
Post Reply
son_ds
Posts: 1
Joined: Tue Nov 26, 2019 5:16 pm

No Date condition in Filter

Post 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?
banzaay
Posts: 12
Joined: Fri Feb 15, 2019 4:18 pm

Re: No Date condition in Filter

Post 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
User avatar
iconnor
Posts: 2881
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No Date condition in Filter

Post by iconnor »

Use Start Date. Events have both a start and an end.
banzaay
Posts: 12
Joined: Fri Feb 15, 2019 4:18 pm

Re: No Date condition in Filter

Post 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 1836 times
Start Date <= -10 days

But it is not working.
User avatar
iconnor
Posts: 2881
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No Date condition in Filter

Post 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.
Post Reply