script to auto delete dial lists

[tradecomedia]

Vicibox 6.0.4 from .iso | Vicidial 2.12-538a Build 160122-1401 | Asterisk 1.8.32.3-vici | CLuster setup: 1 web 1 DB 5 telephony | No Digium/Sangoma Hardware | No Extra Software After Installation

is it possible to create a script that will automatically delete a diallist after a certain period of time? For instance.. we create a new list everyday per campaign and after 60 days we have to delete the list manually. I have purchased the managers manual and the info on scripting is not really covered.

thank you!

[mflorell]

Yes, you can create a script to do that, it's actually just simple SQL, but you need to define the exact conditions under which you would delete a list before you can write the SQL. Also, do you want to delete the leads within the list, or just the list entry?

[tradecomedia]

ideally, we would like to delete the lists and all the data to help keep the size of our database somewhat manageable and to have it automated.