Filter Rule (recall leads called 15 times after 30Days)

[renzocaso]

Hello Guys ( hope this is possible)
I been trying to setup a Filter rule who allow me recall leads called 15 times or more only after pass 30 days from been called. (also called less than 15 in normal way.)

I tried this but no good result at all.

called_count < "15" OR (called_count>="15" AND last_local_call_time >= DATE_SUB(NOW(), INTERVAL 30 DAY))

any help I really appreciate

thank you very much

MY SETUP
Voip no T1 or PSTN
Samgoma Timer
i5 4Gb ram
VERSION: 2.4-309a
BUILD: 110430-1642
Goautodial
Asterisk 1.4.39.1-vici

[williamconley]

Run your filter in phpMyAdmin and see what your results are. Put SELECT * FROM vicidial_list WHERE in front of it.

You may find you want to change >= to <=

last_local_call_time <= DATE_SUB

to ensure the last call date is BEFORE 30 days and not AFTER 30 days

[renzocaso]

I will try
thank you like allays




MY SETUP
Voip no T1 or PSTN
Samgoma Timer
i5 4Gb ram
VERSION: 2.4-309a
BUILD: 110430-1642
Goautodial
Asterisk 1.4.39.1-vici