Postal code filter

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Postal code filter

Postby hansg » Wed Feb 10, 2021 9:21 am

Hi,

I am trying to use a filter to dial specific postal codes. The postal codes are UK format which start with usually 2 letters followed by 1 or 2 numbers
Example BA14 7HP

I am trying to filter so that the system only calls for example BA10 XXX, BA11 XXX and BA12 XXX

I have succesfully used filter to just BA10 by using:

Code: Select all
postal_code LIKE "BA10%"


I have tried

Code: Select all
postal_code LIKE "BA10%" AND
postal_code LIKE "BA11%" AND
postal_code LIKE "BA12%"


When I apply that all of the leads are removed from the hopper and dialable leads.

What is it I am doing wrong when trying to apply multiple together?
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: Postal code filter

Postby carpenox » Wed Feb 10, 2021 12:14 pm

try: postal_code like ('BA10%','BA11%','BA12%')

or "in" instead of "like"
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Postal code filter

Postby hansg » Wed Feb 10, 2021 1:22 pm

Those options you gave me didn't work but I managed to get it working by using

postal_code LIKE 'BA10%' OR
postal_code LIKE 'BA11%' OR
postal_code LIKE 'BA12%'
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: Postal code filter

Postby carpenox » Thu Feb 11, 2021 3:57 pm

nice, good post back
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 96 guests