##Google Analz## ##Microsoft## ##Googel## Swanand: Lead recycling using mysql query

Monday, 21 October 2013

Lead recycling using mysql query

You can churn list with disposition in vicidial / Goautodial through back end with such command....

mysql -p

use asterisk;

update vicidial_list set status='NEW',called_since_last_reset='N' where list_id='104'and status='A';

only need to change list id and status, through this command you can churn a particular disposition.


For multiple list id and status

update vicidial_list set status='NEW',called_since_last_reset='N' where list_id in ('104','105','133') and status in ('A','NA')

No comments:

Post a Comment

Featured post

Vicidial With WebRTC

Vicidial With WebRTC VICIDial is well known open source call center software. It has been in use by many small to large scaled con...