Filter for Zip Codes

[udfxrookie]

I need to create a filter to allow only the zip codes in the filter to be dialed.... as example:
Zip code 12345, 12346, 123457 to call

would I use
postal_code IN ('12345','12346','12347')

and just keep adding zip codes?

[udfxrookie]

so far it looks solid

[udfxrookie]

Ok... trying the opposite now... how do I filter OUT zip codes.... I tried
postal_code OUT ('15010')
but it's not working... still have leads with zip code 15010 going through the dialer... any ideas?

[Acidshock]

postal_code NOT IN ('12345','12346','12347')

[udfxrookie]

TY!!!!!! =)

[udfxrookie]

Whole lotta not working put in the filter box postal_code NOT IN ('15010') and they're still coming in from 15010

[DomeDan]

You can try it out with "TEST ON CAMPAIGN:" if you got that feature in your version.
else you can find out the lead_id of that lead and try this in mysql:
select * from vicidial_list where postal_code NOT IN ('15010') and lead_id = 'the-lead'
if you see the lead then maybe the postal_code contains a space of something

[udfxrookie]

Still not working:

Code: Select all

Postal_Code NOT IN (15010,15037,15024,15014,15025)

Please please help

[DomeDan]

Postal_Code should not be capital letters
(15010,15037,15024,15014,15025) should be ('15010','15037','15024','15014','15025') because postal_code is a varchar

[udfxrookie]

trying with

Code: Select all

postal_code NOT IN ('15010','15037','15024','15014','15025')

now =) ty for teaching me the basics

[williamconley]

Code: Select all

mysql> select user from vicidial_users limit 1;
+------+
| user |
+------+
| 1102 |
+------+
1 row in set (0.00 sec)

mysql> select User from vicidial_users limit 1;
+------+
| User |
+------+
| 1102 |
+------+
1 row in set (0.00 sec)

mysql> select UsEr from vicidial_users limit 1;
+------+
| UsEr |
+------+
| 1102 |
+------+
1 row in set (0.00 sec)


I will note, however, that mysql field names are not case sensitive.

[udfxrookie]

So what's stopping this fitter from working

[williamconley]

perhaps you forgot to clear the hopper?

[udfxrookie]

Grrrr... never thought I'd have issues with this. I put in:

Code: Select all

postal_code NOT IN (`15010`,`15037`,`15024`,`15014`,`15025`,`15017`)

and I'm still getting calls from these zip codes, what in the world could be wrong with the coding... I even thought my back ticks were wrong b/c that was where I kept messing up the sql in asterisk by using a '

I also though:

Code: Select all

postal_code NOT IN (15010,15037,15024,15014,15025,15017)

would work but it isn't.

[mflorell]

don't use backticks, use quotes.

[williamconley]

single quotes

'15017'

[udfxrookie]

Ok, at first I tried this based on what Matt mentioned:

Code: Select all

postal_code NOT IN ("15010","15037","15024","15014","15025","15017")

but your saying to try this:

Code: Select all

postal_code NOT IN ('15010','15037','15024','15014','15025','15017')

The first way I do the test and it shows:

Code: Select all

Show Dialable Leads Count -

CAMPAIGN: Energy
LISTS: '9500','9502','9506','9507','9604','9605','9616'
STATUSES: CBAM AA B DROP CALLBK N A NEW -
FILTER: NONENERGY
CALL LIMIT: 0 CALL TIME: 9am-9pm

This campaign has 12303 leads to be dialed in those lists

The second way shows this for results:

Code: Select all

Show Dialable Leads Count -

CAMPAIGN: Energy
LISTS: '9500','9502','9506','9507','9604','9605','9616'
STATUSES: CBAM AA B DROP CALLBK N A NEW -
FILTER: NONENERGY
CALL LIMIT: 0 CALL TIME: 9am-9pm

This campaign has 0 leads to be dialed in those lists

[williamconley]

that's different. i've never used double quotes in a mysql filter, but if it works go with it!

[udfxrookie]

Thats the thing... it shows that there are leads in the dialer doing it the first way but it isn't operational, it's not filtering out those zip codes. I still see them coming to the agents, the other way didn't work either...

[williamconley]

is that the only thing in the filter? or is this a "partial showing" of a bigger filter?

[udfxrookie]

that's it, just trying filters now, can't make it past this one lol

[williamconley]

you may have an old bug. perhaps an upgrade is in order. i do remember some clients having difficulty getting filters to work back there somewhere.