Page 1 of 1

Filter leads by state

PostPosted: Thu Apr 01, 2010 10:32 pm
by 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. :)

PostPosted: Fri Apr 02, 2010 12:56 am
by 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

PostPosted: Tue Dec 27, 2011 12:04 pm
by 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?

PostPosted: Tue Dec 27, 2011 4:11 pm
by 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

Re: Filter leads by state

PostPosted: Tue Jun 25, 2013 9:33 am
by 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

Re: Filter leads by state

PostPosted: Wed Jun 26, 2013 2:42 am
by 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')

Re: Filter leads by state

PostPosted: Wed Jun 26, 2013 8:30 am
by rrb555
Thank you it is working now

Re: Filter leads by state

PostPosted: Thu Oct 20, 2016 1:17 pm
by 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?