@AKanji-WMF I'm adding @MDemosWMF as well as she needs to add this DMA to gifts coming in still that need this DMA

"I'm searching for a Direct Mail Appeal under Gift Data field for contributions. I know this was in Civi but I somehow can't find it anymore on the drop down or when I go and look at Custom fields where you can add in new options. It was related to the Major Gifts Year End Appeal - Annual Fund Appeal 2022 - Mailing and was on a number of records amounting to about $2m for this appeal. Is there anyway to find deleted Direct Mail Appeals in Civi and reinstate them? here is a CID 3656089 for a donor that I know their most recent gift had this direct mail appeal."

Here are the missing ones (deleted when the wrong option value was deleted - also see
select * FROM log_civicrm_option_value WHERE log_conn_id ='6454c2d96e481JbZa' AND log_action='Delete'

Select contact_id, entity_id as contribution_id FROM log_civicrm_value_1_gift_data_7 LEFT JOIN civicrm_contribution c ON c.id = entity_id WHERE log_conn_id ='6454c2d96e481JbZa';

+------------+-----------------+
374 rows in set (0.008 sec)

Update query - took 3 mins

UPDATE civicrm_value_1_gift_data_7 SET appeal = 'Annual Fund Appeal 2022 - Mailing' WHERE entity_id IN (Select entity_id as contribution_id FROM log_civicrm_value_1_gift_data_7 LEFT JOIN civicrm_contribution c ON c.id = entity_id WHERE log_conn_id ='6454c2d96e481JbZa') ;

Change 928660 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Restore inadvertantly deleted option values

https://gerrit.wikimedia.org/r/928660

Change 928660 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Restore inadvertantly deleted option values

https://gerrit.wikimedia.org/r/928660

@RLewis I've run that update - hopefully they are back now (I haven't done any QA yet)

OK - I spot checked 1 & he looked OK

@Eileenmcnaughton I'm not seeing the Annual Fund Appeal 2022 - Mailing DMA in the drop down as a selection

@MDemosWMF this is one of the contacts we re-added it to - https://civicrm.wikimedia.org/civicrm/contact/view/contribution?reset=1&action=update&id=80415917&cid=1928994&context=contribution - seems to be there?

@MDemosWMF - I can see the drop down option in Civi when searching.

@Eileenmcnaughton - all looks ok to me and the revenue looks like what it was in Civi for this DMA. Thank you!

I see it now! Thanks!