activating and reseting lot of lists

[eijal]

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

[mflorell]

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');

[eijal]

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]


[mflorell]

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.