vicidial.org

Hi
How can I reset and activate and disactivate many lists at the same time?
Now, I am activating and reseting many lists one by one, and some times it takes a lot of time. How can do that with just one click with a sql sentence?
THANK YOU

It should be really easy to do with a couple SQL statements:

UPDATE vicidial_lists set active='Y' where list_id IN('101','102','103');

UPDATE vicidial_list SET called_since_last_reset='N' where list_id IN('101','102','103');

mflorell wrote:It should be really easy to do with a couple SQL statements:

UPDATE vicidial_lists set active='Y' where list_id IN('101','102','103');

UPDATE vicidial_list SET called_since_last_reset='N' where list_id IN('101','102','103');

Thank you again Matt:
I'll use something like this:

Code: Select all

UPDATE vicidial_lists set active='Y' where (list_id >= 101 AND list_id <= 200);

UPDATE vicidial_list SET called_since_last_reset='N' where (list_id >= 101 AND list_id <= 200);[/quote]


Glad it's working for you, I am thinking it might be nice to have a feature for this where you could go to a page and use a multiple select list to define what lists to reset/activate/deactivate all at once.