Page 1 of 1
Filter leads by state
Posted:
Thu Apr 01, 2010 10:32 pmby 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.
Posted:
Fri Apr 02, 2010 12:56 amby 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
Posted:
Tue Dec 27, 2011 12:04 pmby 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?
Posted:
Tue Dec 27, 2011 4:11 pmby 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
Posted:
Tue Jun 25, 2013 9:33 amby 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
Posted:
Wed Jun 26, 2013 2:42 amby 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
Posted:
Wed Jun 26, 2013 8:30 amby rrb555
Thank you it is working now
Re: Filter leads by state
Posted:
Thu Oct 20, 2016 1:17 pmby 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?