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 » Tue Nov 26, 2019 5:25 pm

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 » Tue Dec 17, 2019 2:39 pm

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: 1062
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No Date condition in Filter

Post by iconnor » Thu Dec 19, 2019 12:08 am

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 » Thu Dec 19, 2019 9:23 am

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

But it is not working.

User avatar
iconnor
Posts: 1062
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No Date condition in Filter

Post by iconnor » Fri Dec 20, 2019 2:54 pm

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

Who is online

Users browsing this forum: No registered users and 3 guests