how to fetch DNC list ????

All installation and configuration problems and questions

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

how to fetch DNC list ????

Postby abhasbajpai » Tue Sep 26, 2006 12:09 am

how to fetch dnc list from leads
which agents have desposed as dnc
with clints name address and phone nos and list id for that perticular date
if it could be done through mysql querry
then please tell me the querry which i should put in mysql prompt
help needed
thanks
abhasbajpai
 
Posts: 89
Joined: Sun Aug 13, 2006 1:22 am

Postby mflorell » Tue Sep 26, 2006 10:52 am

Select * from vicidial_list where status='DNC' and modify_date > "2006-05-05 00:00:00" and modify_date < "2006-05-05 23:59:59";
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby abhasbajpai » Wed Sep 27, 2006 12:54 am

thanks you very much
abhasbajpai
 
Posts: 89
Joined: Sun Aug 13, 2006 1:22 am


Return to Support

Who is online

Users browsing this forum: No registered users and 114 guests