I'm hoping someone has a trick to do this. I have a lot of lists that were saved from extractions that I was working on for mailing/telefunding campaigns, that I have since then decided not to use, but I am unable to delete them.
I get the error message that this list is in use and cannot be deleted but I have gone through so many of my lists and extractions and do not see any of these lists in use (nor should any of my collegues be using them.)
How can I delete???? I know I could just inactivate them, which I have. But they still show up in list manager and I would like to get rid of them all together because their presence is more confusing than anything else.
Suggestions???
We also do this with control groups. I have one that is called Archival and recently I just ran a simple update to assign this control group to all former staff lists and any that had not been used in the last year.
Only certain security groups have access to the archival control group and these are ones that are not used on a day to day basis
From: Marta Garczarczyk <bounce-martagarczarczyk9387@tessituranetwork.com>Sent: 5/5/2009 2:05:00 PM
For some reason it doesn't look like I saved them and since I'm a novice at SQL I'm hesitant to share something that updates tables without retesting them first.Find the control group id number for the control group you want to assign to them in tr_control_group in the system tables and let your IT person know that you need to update the control_group column with that id number in the t_list table based upon either last_used_dt, created_by or whatever you decide to filter with.