[SalesForce] How to find out the deleted record in After delete trigger

I am writing a trigger to handle after insert,after update and after delete events.
I am using trigger.old for after delete.But, how to differentiate the deleted record from the rest of the records of the object?

What I have done so far is :

List<Object__c) lstTriggerOld = trigger.old;
List<Object__c> lstAllRecords = [SELECT Id FROM Object__c WHERE ID != NULL];
List<Object__c> deletedRecords = [SELECT Id FROM Object__c WHERE ID IN :lstTriggerOld AND ID NOT IN : lstAllRecords ];

But the last list is not fetching any rows.

Can someone help?

Best Answer

To get or Query deleted records you need to use ALL ROWS So your query will be

List<Object__c> deletedRecords = [SELECT Id FROM Object__c WHERE ID IN :lstTriggerOld AND ID NOT IN : lstAllRecords ALL ROWS];

All Rows Keyword

Related Solutions

[SalesForce] After Delete – Need To “Cleanup” When An Opp Is Deleted

Here is my stab at this. If it is a delete trigger, the values on the Account will be set to 0, since Accounts instantiated will have 0 values. I've switched to using Trigger.old in case of a delete trigger.

trigger OpportunityAfter on Opportunity(after insert, after delete, after update) {
    Map<Id, Account> aggregateValMap = new Map<Id, Account>();

    for (Opportunity opp : Trigger.isDelete ? Trigger.old : Trigger.new) {
        Account acc = aggregateValMap.get(opp.AccountId);
        if (acc == null) {
            // initialise aggregates to 0
            acc = new Account(Id = opp.AccountId, Aggregate1__c = 0, Aggregate2__c = 0, ...);
            aggregateValMap.put(opp.AccountId, acc);
        }

        if (!Trigger.isDelete) { // do not add values if record is deleted
            acc.Aggregate1__c += opp.Aggregate1__c;
            acc.Aggregate2__c += opp.Aggregate2__c;
        }
    }

    if (!aggregateValMap.isEmpty())
        Database.update(aggregateValMap.values());
}

[SalesForce] Before Delete Trigger record selection – contents of Trigger.old

When the Trigger.isDelete is true, all the records in Trigger.old are being deleted.

Best Answer

Related Solutions

[SalesForce] After Delete – Need To “Cleanup” When An Opp Is Deleted

[SalesForce] Before Delete Trigger record selection – contents of Trigger.old

Related Topic