[SalesForce] Update Trigger on Parent record on Roll-up summary field when child records are inserted or deleted

I want to build an update trigger on a rollup summary field.

Say I have a parent record A, A have 1000 children records linked with a Master-Detail relationship.

1.First Operation: delete 1000 records, if the code is like

List<Child__c> children = [select id from Child__c where parentid = A.Id];
delete children;

How many times would the update trigger on parent record A run?

Is it 5? What if the second 200 batch is being deleted when the first update trigger is running? I'm confused with the execution order and the events start&end order.

2.Second Operation: insert 1000 child records from data loader or any external app.

How many times would the update trigger on parent record A run?
Is it 5? Is it similar to the delete operation?

Thanks

Update

The Roll up summary field is a "SUM" of it's children records field num__c which has a number type.

The question assumes the num__c field of the deleted&inserted children records have value on this field.

The question also specified 1000 child records belongs to a same parent record

Best Answer

The update triggers on parent will be fire .200 child records are processed at a time when you delete 1000 records .This means there will be 5 chunks .Lets say 200 child belongs to 10 parent records ,trigger.new will have 10 parent records .

The trigger on Parent would run for update case .In your case you are deleting or inserting and that should trigger update triggers on parent records .

To confirm this behavior just did a quick experiment

1.Create a parent object and a child object .Associate them via master detail .

2.Create a number field on the child record .

3.Create a roll up summary field on the parent record summing the number field that's created in previous field

4.Create a trigger on the parent record like below

trigger triggerSpeaker on Parent__c (before update) {
  if(trigger.isbefore && trigger.isupdate){
    for(Parent__c sp:trigger.old ){
      sp.addError('You cannot update me');
    }
  }
 }

5.Delete or insert the data into child objects via data loader or developer console.You should see the add error indicating triggers fire

Related Solutions

[SalesForce] Update parent field with field from child record

I would create a custom button on the child object page layout. This button would open a VF page. I would use the action attribute of that page to do this logic, and then return the user to the child record.

<apex:page StandardController="Child__c" extensions="customExtension" action="{!copyFirmwareField}"/>

Apex

public class customExtension{

     private final Child__c myChild;

     public CheckForExpiredMilestonesNowExtension(ApexPages.StandardController stdController){
          this.myChild = (Child__c)stdController.getRecord();
          this.myChild = [Select Id, Name, Parent__c From Child__c Where Id =: myChild.Id];
     }

     public PageReference copyFirmwareField(){
          Parent__c parent = new Parent__c(Id = myChild.Parent__c, Firmware__c = myChild.Firmware__c);
          update parent;
          PageReference page = new PageReference('/' + myChild.Id);
          page.setRedirect(true);
          return page;
     }
}

[SalesForce] Rollup Summary Trigger when I change the parent record

The main issue that you're facing is the SOQL statement inside of your for loop, which is a sure fire way to run into limits in triggers.

Beyond that though, I can't quite understand what you're trying to accomplish. YTD_Booking__c is always getting reset to 0 and then reset to the latest opp amount. It's not actually summing the opps at all, but each time you go through the loop, you are setting the field to the latest opp amount. What you really want here can be accomplished without apex, as far as I can tell from your requirements.

You could create a rollup summary field that sums the amount of 'won' opportunities related to an account.

If you still feel that you need to do this in apex, you should consider an aggregate query.

AggregateResult[] groupedResults = [SELECT AccountId, SUM(Amount) bookingTotal
    FROM Opportunity 
    WHERE Stage__c = 'won'
    GROUP BY AccountId];
for (AggregateResult ar : groupedResults)  {
    System.debug('Account Id' + ar.get('AccountId'));
    System.debug('Total Bookings' + ar.get('bookingTotal'));
}

There are also some other curiosities worth calling out. Why are you using a custom stage field on opportunity, where there is a native stage field (StageName). Also, You don't need to create a set of Ids from the trigger set, your Query WHERE clause can use trigger.new or trigger.old but you need to use the IN clause instead of equals:

for(Account acc:[SELECT Id,YTD_Booking__c FROM Account where id IN : enq])

Best Answer

Related Solutions

[SalesForce] Update parent field with field from child record

[SalesForce] Rollup Summary Trigger when I change the parent record

Related Topic