Due to state of emergency in Florida MySQL script

[davesdatasystems]

Ok, i figured i would ask here, since i cant seem to get this script right. Or if there is a direct setting in vicidial to do this, that would be even better.

So i do not want to call Florida while it is in the state of emergency, and i got the script working fine for not calling Florida, i used state NOT IN('FL'), but i also wanted to filter out the area codes as well, so to do the state and area codes, i used state NOT IN('FL') & left(phone_number,3) NOT IN ('239','305','321','352','386','407','561','689','727','754','772','786','813','850','863','904','941','954') but when i did the test, it said it would dial 0 leads. So i am wondering what i might of did wrong on the script, or is there somewhere else in vicidial that will filter out the states without using filters.

[ambiorixg12]

I would suggest you run the query directly against the vicidial_list table and verify it return leads to dial out

[TwistedFister]

post just as is in filters

left(phone_number,3) <> '239' AND
left(phone_number,3) <> '305' AND
left(phone_number,3) <> '321' AND
left(phone_number,3) <> '352' AND
left(phone_number,3) <> '386' AND
left(phone_number,3) <> '407' AND
left(phone_number,3) <> '561' AND
left(phone_number,3) <> '727' AND
left(phone_number,3) <> '754' AND
left(phone_number,3) <> '772' AND
left(phone_number,3) <> '786' AND
left(phone_number,3) <> '813' AND
left(phone_number,3) <> '850' AND
left(phone_number,3) <> '863' AND
left(phone_number,3) <> '904' AND
left(phone_number,3) <> '941' AND
left(phone_number,3) <> '954'

name it florida or whatever ... save then under campaign setting go to filter and select whatever you named it.

[williamconley]

I would suggest you run the query directly against the vicidial_list table and verify it return leads to dial out

Agreed

plus: use "and" not "&"