Deleting Old Lists

[ctc_olsen]

Hi everyone. Everyday, we create around 15 lists with around 1500 leads on it on average. That's on a daily basis. Right now, we have a lot of lists that needs to be deleted and deleting it through admin GUI is quite a long task and I will be wasting a huge portion of my time doing it.

I tried another solution by deleting it under MySql but only the leads on the lists gets deleted. The lists are still there with just with no leads on eit. How can I properly delete lists and the leads on that list ID?

[williamconley]

You can delete the list the same way you deleted the leads, they are merely in a different table.

Leads are in vicidial_list
Lists are in vicidial_lists

Note the extra "s" at the end of the table name.

[ctc_olsen]

Thanks William. By the way, I found the command on MySQL to do this. It's basically a two step process. The lead list ID is just an example. Hope this helps somebody.

***delete lists***
delete from vicidial_list where list_id BETWEEN '15695' AND '15999';


***delete empty lists***
delete from vicidial_lists where list_id BETWEEN '15695' AND '15999';