filter to dial only certain area codes

All installation and configuration problems and questions

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

filter to dial only certain area codes

Postby kchung » Thu Jan 18, 2007 4:54 pm

How can I filter the leads to dial only specific area codes?

I tried:
Code: Select all
'LEFT(phone_number, 3)' = 'XXX' and
'LEFT(phone_number, 3)' = 'YYY' and
...
...
'LEFT(phone_number, 3)' = 'ZZZ'


Substitute the letters for your favorite area codes you wanna call.

It doesn't seem to work. [/i]
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

Postby mflorell » Thu Jan 18, 2007 5:17 pm

Have you tried adding this filter to the campaign:

phone_number LIKE "312%"
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby palito » Fri Jan 19, 2007 1:36 am

Also, use "OR" instead of "AND", as in:

phone_number LIKE "XXX%" OR
phone_number LIKE "YYY%" OR
...
...
phone_number LIKE "ZZZ%"
palito
 
Posts: 18
Joined: Tue Jan 16, 2007 4:03 pm

Postby kchung » Wed Jan 24, 2007 7:32 pm

Thanks everyone, i'll give it a try.
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

doubt

Postby devafree » Thu Jan 25, 2007 11:25 am

Will a filter like phone like 'xxx%' dial out the leads matching
or would it not dial out the matching leads, i.e filter out those leads?

devafree
devafree
 
Posts: 180
Joined: Wed Sep 20, 2006 5:03 pm

Postby palito » Thu Jan 25, 2007 12:43 pm

I understand that the filters refers to whatever you'd place after the WHERE in the SQL clause. Therefore, what you write in for the filter, is what will be selected. If you want to filter out, you can use NOT, as in phone_number NOT LIKE "XXX%".

There are plenty of good SQL tutorials you can look into as well, those will give you more ideas.

Regards
palito
 
Posts: 18
Joined: Tue Jan 16, 2007 4:03 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 91 guests