filter to dial only certain area codes

[kchung]

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]

[mflorell]

Have you tried adding this filter to the campaign:

phone_number LIKE "312%"

[palito]

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

phone_number LIKE "XXX%" OR
phone_number LIKE "YYY%" OR
...
...
phone_number LIKE "ZZZ%"

[kchung]

Thanks everyone, i'll give it a try.

[devafree]

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

[palito]

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