VICIdial filter

Re: How to filter out specific local call time hours?

by mflorell » Mon Oct 25, 2021 4:20 pm

We don't really have a single reference for filter examples, but there are probably dozens spread out through the Forums. Here are a few:

Below are several examples of Filters that can be used to further limit VICIdial outbound calling

72 hour block on auto-Answering-Machine detected calls -
This specific example was used to comply with the UK's OFCOM auto-dialing regulations to not call back auto-detected answering machines within 3 days of the last attempt:
( ( (status='AA') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -3 DAY),' ',CURTIME()) ) ) or (status != 'AA') )

Two examples for blocking areacodes -
These examples are for two areacodes in Puerto Rico:
(left(phone_number,3) NOT IN('787','939'))
(phone_number NOT LIKE '787%' AND phone_number NOT LIKE '939%')

Exclude a list of cities:
(city NOT IN('london','paris','tampa'))

Include only specific states:
state IN('FL','NY','CA')

Do not call NI(Not Interested) leads for 7 days
( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

No more than one call per lead per 24 hours:
(last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -1 DAY),' ',CURTIME()) )

Multiple filters in one -
This filter was designed to limit the call attempts, states and time zones of leads:
called_count IN('7','8','9') and state NOT IN('CA','OR','WA') and gmt_offset_now IN('-4','-5')

This Filter would exclude the 12-oclock hour for EST(Eastern Standard Time) leads on an EST-configured system, during standard time only(not during daylight savings time):

( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') )

mflorell

Site Admin

 

Posts: 17877

Joined: Wed Jun 07, 2006 3:45 pm

Location: Florida