Delete NPC Data from Environment

npc-clean.apex

String prefix = 'cte';

// Get gift transactions
List<GiftTransaction> lstGT = [SELECT Id FROM GiftTransaction WHERE md_npc_pack__Platform_Key__c LIKE :prefix + '%'];
System.Debug(lstGT);

// Delete installments associated with Gift Transasctions
List<cpm__Installment__c> lstI = [SELECT Id FROM cpm__Installment__c WHERE fdff__GiftTransaction__c IN :lstGT];
System.Debug(lstI);
if (lstI.size() > 0) delete lstI;

// Delete gift transactions
delete lstGT;

// --------------------------

// Delete gift commitments
List<GiftCommitment> lstGC = [SELECT Id FROM GiftCommitment WHERE md_npc_pack__Platform_Key__c LIKE :prefix + '%'];
System.Debug(lstGC);
delete lstGC;

// --------------------------

// Delete campaigns
List<Campaign> lstC = [SELECT Id FROM Campaign WHERE movedata__Platform_Key__c LIKE :prefix + '%'];
System.Debug(lstC);
delete lstC;

// --------------------------

// Get Accounts by Key
List<Account> lstA = [
    SELECT Id FROM Account WHERE Id IN (SELECT movedata__Account__c FROM movedata__Account_Platform_Key__c WHERE movedata__Platform_Key__c LIKE :prefix + '%')
];
System.Debug(lstA);
delete lstA;