Greetings!
I am looking for a way to go in and adjust the Appeal No for an extraction after it has been promoted. We have a few appeals that need to be changed to pull under our Renewal appeal and not the general AF appeal. They have already been extracted/promoted and some of them have transactions/contributions associated with them.
Any thoughts or advice on how to do this?
Many thanks!!
Shannon
Hi Shannon, you can change it with SQL but it's a more complicated change. The appeal number has to be changed in both TX_APPEAL_MEDIA_TYPE and T_Promotion. And if the campaign for your renewals and general appeal is different that needs to be updated in T_Promotion as well. Definitely try it in your Test database first.
Update TX_APPEAL_MEDIA_TYPESet appeal_no = 1234where source_no = 55555Update T_promotionSet appeal_no = 1234where source_no = 55555
That should work. It's been a while since I've done it.