Hi,
I'm looking for another way to delete source codes from patron records beside the Delete Promotions and Source utility.
Ideally, I would like to be able to delete the promotions based on a list and the appeal (we want to unpromote the records of patrons who did not actually receive certain emails or mailings due to address issues, etc.). The current process is based on the appeal and source code, without allowing for me to specify who.
Does anyone have any suggestions or has anyone created a special utility for this?
Thanks,
Sabrina, 92Y
Hi Sabrina,
Did you ever find a solution for this? Am currently wondering the same thing!
Thanks
Josh
Hi Josh,
Not as of yet.
But I'll keep you posted when I do!
Sabrina
I do this through sql. I have a really simple query to remove patrons. You can do it by list or just by customer no if it's just a handful of patrons.
delete T_PROMOTION
where source_no = XXXXX
and customer_no in (select customer_no from t_list_contents where list_no = XXXXX)