Filter leads by state

[powehouse]

Good day! Our agents have been complaining that our system is still dialing EST(when telemarket time do not apply), was wondering on how to make a filter based on states...help would be much appreciated.

[mflorell]

state NOT IN('FL','NY','NJ')


That as a filter will not dial Florida, New York or new Jersey, providing you have the state field populated in vicidial_list of course

[RJCox1979]

So, if I had a list with multiple states, what kind of filter would I use that I could set so VICI would dial ONLY certain states?

[mflorell]

state IN('FL','NY','NJ')


That as a filter will only dial Florida, New York or new Jersey, providing you have the state field populated in vicidial_list of course

[rrb555]

state IN('FL','NY','NJ')

working great thanks but what if I need to add postal code filter? so it will be state and postal code filter

[DomeDan]

Like this:

state IN('FL','NY','NJ') AND postal_code IN ('1234','6789','4321')

you can throw in a NOT too like if you would like to only call Florida but not postal code 1234:

state IN('FL') AND postal_code NOT IN ('1234')

[rrb555]

Thank you it is working now

[d1nn3s]

good day! anyone can help me on how to filter leads by (FOODS) category? i mean the exact code i can write on SQL QWERY?


UPPER(`address3`) = 'FOOD'

that code was given to me last time.. is this an exact code? or? is this code correct?