filter problem

[marcin]

vicidila 2.0.4
when filter is created :
phone_number not like "555%"
the filtering works fine however when filter is created:
phone_number like "555%"
the hopper script is pulling all 555% numbers to be dialed from all the lists.
Even if they are not active and not assign to campaign using the filter.

This is a exact filter I try to use :

city like "Arlington%" or city like "%Barrington%" or city like "Long Grove" or city like "Palatine" or city like "Lake Zurich" or city like "Buffalo Grove" or city like "Inverness" or city like "Tower Lake" or city like "Fox River Grove" or city like "Cary" or city like "Schaumburg" or city like "Glendale%" or city like "Wheeling"

Should I be adding list_id query as well?

[mflorell]

Post the results of the following command when you have this enabled, right after clearing your hopper:

/usr/share/astguiclient/AST_VDhopper.pl --debugX

[marcin]

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: -6.00|-5|1| GMT: 13:32
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 7
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','100','110','111','113','114','115');|
CALLBACK HOLD: 4|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-05-10 8:32:51' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 3|2

|GMT-DAY-HOUR| |13.00-1-232||12.75-1-217||12.50-1-202||12.25-1-147||12.00-1-132||11.75-1-117||11.50-1-102||11.25-1-47||11.00-1-32||10.75-1-17||10.50-1-2||10.25-0-2347||10.00-0-2332||9.75-0-2317||9.50-0-2302||9.25-0-2247||9.00-0-2232||8.75-0-2217||8.50-0-2202||8.25-0-2147||8.00-0-2132||7.75-0-2117||7.50-0-2102||7.25-0-2047||7.00-0-2032||6.75-0-2017||6.50-0-2002||6.25-0-1947||6.00-0-1932||5.75-0-1917||5.50-0-1902||5.25-0-1847||5.00-0-1832||4.75-0-1817||4.50-0-1802||4.25-0-1747||4.00-0-1732||3.75-0-1717||3.50-0-1702||3.25-0-1647||3.00-0-1632||2.75-0-1617||2.50-0-1602||2.25-0-1547||2.00-0-1532||1.75-0-1517||1.50-0-1502||1.25-0-1447||1.00-0-1432||0.75-0-1417||0.50-0-1402||0.25-0-1347||0.00-0-1332||-0.25-0-1317||-0.50-0-1302||-0.75-0-1247||-1.00-0-1232||-1.25-0-1217||-1.50-0-1202||-1.75-0-1147||-2.00-0-1132||-2.25-0-1117||-2.50-0-1102||-2.75-0-1047||-3.00-0-1032||-3.25-0-1017||-3.50-0-1002||-3.75-0-947||-4.00-0-932||-4.25-0-917||-4.50-0-902||-4.75-0-847||-5.00-0-832||-5.25-0-817||-5.50-0-802||-5.75-0-747||-6.00-0-732||-6.25-0-717||-6.50-0-702||-6.75-0-647||-7.00-0-632||-7.25-0-617||-7.50-0-602||-7.75-0-547||-8.00-0-532||-8.25-0-517||-8.50-0-502||-8.75-0-447||-9.00-0-432||-9.25-0-417||-9.50-0-402||-9.75-0-347||-10.00-0-332||-10.25-0-317||-10.50-0-302||-10.75-0-247||-11.00-0-232||-11.25-0-217||-11.50-0-202||-11.75-0-147||-12.00-0-132||-12.25-0-117||-12.50-0-102||-12.75-0-47|
|SELECT * FROM vicidial_call_times where call_time_id='main';|
Starting hopper run for DISH_NET campaign- GMT: main HOPPER: 50
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISH_NET' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISH_NET' and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='DISH_NET' and status='READY';|
hopper too low (0|50) starting hopper dump
campaign lists count: 1 | '112'
|SELECT list_id FROM vicidial_lists where campaign_id='DISH_NET' and active='Y';|
no lead filter defined for campaign: DISH_NET
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NA','NEW') and list_id IN('112') and ((gmt_offset_now IN('7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NA','NEW') and list_id IN('112') and ((gmt_offset_now IN('7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-1-232||12.75-1-217||12.50-1-202||12.25-1-147||12.00-1-132||11.75-1-117||11.50-1-102||11.25-1-47||11.00-1-32||10.75-1-17||10.50-1-2||10.25-0-2347||10.00-0-2332||9.75-0-2317||9.50-0-2302||9.25-0-2247||9.00-0-2232||8.75-0-2217||8.50-0-2202||8.25-0-2147||8.00-0-2132||7.75-0-2117||7.50-0-2102||7.25-0-2047||7.00-0-2032||6.75-0-2017||6.50-0-2002||6.25-0-1947||6.00-0-1932||5.75-0-1917||5.50-0-1902||5.25-0-1847||5.00-0-1832||4.75-0-1817||4.50-0-1802||4.25-0-1747||4.00-0-1732||3.75-0-1717||3.50-0-1702||3.25-0-1647||3.00-0-1632||2.75-0-1617||2.50-0-1602||2.25-0-1547||2.00-0-1532||1.75-0-1517||1.50-0-1502||1.25-0-1447||1.00-0-1432||0.75-0-1417||0.50-0-1402||0.25-0-1347||0.00-0-1332||-0.25-0-1317||-0.50-0-1302||-0.75-0-1247||-1.00-0-1232||-1.25-0-1217||-1.50-0-1202||-1.75-0-1147||-2.00-0-1132||-2.25-0-1117||-2.50-0-1102||-2.75-0-1047||-3.00-0-1032||-3.25-0-1017||-3.50-0-1002||-3.75-0-947||-4.00-0-932||-4.25-0-917||-4.50-0-902||-4.75-0-847||-5.00-0-832||-5.25-0-817||-5.50-0-802||-5.75-0-747||-6.00-0-732||-6.25-0-717||-6.50-0-702||-6.75-0-647||-7.00-0-632||-7.25-0-617||-7.50-0-602||-7.75-0-547||-8.00-0-532||-8.25-0-517||-8.50-0-502||-8.75-0-447||-9.00-0-432||-9.25-0-417||-9.50-0-402||-9.75-0-347||-10.00-0-332||-10.25-0-317||-10.50-0-302||-10.75-0-247||-11.00-0-232||-11.25-0-217||-11.50-0-202||-11.75-0-147||-12.00-0-132||-12.25-0-117||-12.50-0-102||-12.75-0-47|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for TEST_IN campaign- GMT: 24hours HOPPER: 5
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TEST_IN' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TEST_IN' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='TEST_IN' and status='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 0 | ''
|SELECT list_id FROM vicidial_lists where campaign_id='TEST_IN' and active='Y';|
no lead filter defined for campaign: TEST_IN
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-1-232||12.75-1-217||12.50-1-202||12.25-1-147||12.00-1-132||11.75-1-117||11.50-1-102||11.25-1-47||11.00-1-32||10.75-1-17||10.50-1-2||10.25-0-2347||10.00-0-2332||9.75-0-2317||9.50-0-2302||9.25-0-2247||9.00-0-2232||8.75-0-2217||8.50-0-2202||8.25-0-2147||8.00-0-2132||7.75-0-2117||7.50-0-2102||7.25-0-2047||7.00-0-2032||6.75-0-2017||6.50-0-2002||6.25-0-1947||6.00-0-1932||5.75-0-1917||5.50-0-1902||5.25-0-1847||5.00-0-1832||4.75-0-1817||4.50-0-1802||4.25-0-1747||4.00-0-1732||3.75-0-1717||3.50-0-1702||3.25-0-1647||3.00-0-1632||2.75-0-1617||2.50-0-1602||2.25-0-1547||2.00-0-1532||1.75-0-1517||1.50-0-1502||1.25-0-1447||1.00-0-1432||0.75-0-1417||0.50-0-1402||0.25-0-1347||0.00-0-1332||-0.25-0-1317||-0.50-0-1302||-0.75-0-1247||-1.00-0-1232||-1.25-0-1217||-1.50-0-1202||-1.75-0-1147||-2.00-0-1132||-2.25-0-1117||-2.50-0-1102||-2.75-0-1047||-3.00-0-1032||-3.25-0-1017||-3.50-0-1002||-3.75-0-947||-4.00-0-932||-4.25-0-917||-4.50-0-902||-4.75-0-847||-5.00-0-832||-5.25-0-817||-5.50-0-802||-5.75-0-747||-6.00-0-732||-6.25-0-717||-6.50-0-702||-6.75-0-647||-7.00-0-632||-7.25-0-617||-7.50-0-602||-7.75-0-547||-8.00-0-532||-8.25-0-517||-8.50-0-502||-8.75-0-447||-9.00-0-432||-9.25-0-417||-9.50-0-402||-9.75-0-347||-10.00-0-332||-10.25-0-317||-10.50-0-302||-10.75-0-247||-11.00-0-232||-11.25-0-217||-11.50-0-202||-11.75-0-147||-12.00-0-132||-12.25-0-117||-12.50-0-102||-12.75-0-47|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for CSERV campaign- GMT: 24hours HOPPER: 20
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='CSERV' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='CSERV' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='CSERV' and status='READY';|
hopper too low (0|20) starting hopper dump
campaign lists count: 0 | ''
|SELECT list_id FROM vicidial_lists where campaign_id='CSERV' and active='Y';|
campaign lists count: 0 | ''
lead filter CLEAN defined for CSERV
|and city like "Arlington%" or city like "%Barrington%" or city like "Long Grove" or city like "Palatine" or city like "Lake Zurich" or city like "Buffalo Grove" or city like "Inverness" or city like "Tower Lake" or city like "Fox River Grove" or city like "Cary" or city like "Schaumburg" or city like "Glendale%" or city like "Wheeling" |
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) and city like "Arlington%" or city like "%Barrington%" or city like "Long Grove" or city like "Palatine" or city like "Lake Zurich" or city like "Buffalo Grove" or city like "Inverness" or city like "Tower Lake" or city like "Fox River Grove" or city like "Cary" or city like "Schaumburg" or city like "Glendale%" or city like "Wheeling" ;|
leads to call count: 3268
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) and city like "Arlington%" or city like "%Barrington%" or city like "Long Grove" or city like "Palatine" or city like "Lake Zurich" or city like "Buffalo Grove" or city like "Inverness" or city like "Tower Lake" or city like "Fox River Grove" or city like "Cary" or city like "Schaumburg" or city like "Glendale%" or city like "Wheeling" ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='3268' where campaign_id='CSERV';|
Getting Leads to add to hopper
|SELECT lead_id FROM vicidial_hopper where campaign_id='CSERV';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') and lead_id NOT IN('0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) and city like "Arlington%" or city like "%Barrington%" or city like "Long Grove" or city like "Palatine" or city like "Lake Zurich" or city like "Buffalo Grove" or city like "Inverness" or city like "Tower Lake" or city like "Fox River Grove" or city like "Cary" or city like "Schaumburg" or city like "Glendale%" or city like "Wheeling" order by lead_id asc limit 20;|
Adding to hopper: 20
LEAD INSERTED: 1|5|
LEAD INSERTED: 1|6|
LEAD INSERTED: 1|7|
LEAD INSERTED: 1|8|
LEAD INSERTED: 1|9|
LEAD INSERTED: 1|10|
LEAD INSERTED: 1|11|
LEAD INSERTED: 1|12|
LEAD INSERTED: 1|13|
LEAD INSERTED: 1|14|
LEAD INSERTED: 1|15|
LEAD INSERTED: 1|16|
LEAD INSERTED: 1|17|
LEAD INSERTED: 1|18|
LEAD INSERTED: 1|19|
LEAD INSERTED: 1|20|
LEAD INSERTED: 1|21|
LEAD INSERTED: 1|22|
LEAD INSERTED: 1|23|
LEAD INSERTED: 1|24|
DONE with this campaign
DONE. Script execution time in seconds: 1

[mflorell]

Looks like you aren't putting your parameters in parantheses() while using ORs, meaning that yes they are going outside of the original query restraints.