Lead Filter, Multiple Filters.

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

Moderators: enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, s0lid

Lead Filter, Multiple Filters.

Postby Nefariousparity » Tue Apr 30, 2013 2:03 pm

address3 >= ('300000')
AND
vendor_lead_code = ('A')
OR
vendor_lead_code = ('B')
OR
vendor_lead_code = ('C')
OR
vendor_lead_code = ('D')


So the first part refers to home value, with the rest being different levels of credit. Does this look correct? Just curious. Thank you. :)
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm

Re: Lead Filter, Multiple Filters.

Postby williamconley » Tue Apr 30, 2013 2:33 pm

do NOT use "OR".

use vendor_lead_code IN ('A','B','C','D')

instead.

OR will override the rest of the filter you can't see (ie: limit to this list and campaign and those who have not been dialed yet ...) unless you know what you are doing. so do not use OR and stay safe. LOL

TEST it: look at available leads on the campaign. apply the filter. did the number of leads available change in a rational way (ie: probably from 10k to 5k?) or did it go freaky (ie: from 10k to 1.2M!)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20253
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Lead Filter, Multiple Filters.

Postby Nefariousparity » Fri May 03, 2013 11:38 am

Thank you William. You are the man!
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 129 guests