function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Paul H 5Paul H 5 

UPDATE THE PARENT ACCOUNT FIELD WITH THE OPPORTUNITY NAME THAT HAS HIGHEST AMOUNT

trigger OpportunityTrigger on Opportunity (after insert, after update, after delete, after undelete) {
       
    set<Id> accIds = new set<Id>();
    
      if(trigger.isAfter && trigger.isInsert){
        
        for(Opportunity opp : trigger.new){
            
            if(opp.AccountId != null){
                
                accIds.add(opp.AccountId);
            }
        }
    }
    if(trigger.isUpdate && trigger.isUpdate){
        
        for(Opportunity opp : trigger.new){
            
            if(opp.AccountId != Trigger.oldMap.get(opp.Id).AccountId){
                
                accIds.add(opp.AccountId);
                accIds.add(Trigger.oldMap.get(opp.Id).AccountId);
            }
        }
    }
    
    if(trigger.isAfter && trigger.isDelete){
        for(Opportunity opp : trigger.old){
            if(opp.AccountId != null){
                accIds.add(opp.AccountId);
            }
        }
    }
   
  
         List<AggregateResult> aggrList = [Select Name, AccountId, MAX(Amount) maxAmt from Opportunity
                                          where Amount!=null and AccountId IN: accIds
                                          group by Name, AccountId ORDER BY MAX(Amount) desc limit 1];
        
            List<Account> accList = new List<Account>();
            for(AggregateResult aggr: aggrList){
            Id accId = (Id) aggr.get('AccountId');
            String oppName = (String) aggr.get('Name');
            Decimal maxOppAmount = (Decimal) aggr.get('maxAmt');
            Account acc = new Account(Id= accId,HighestOppAmount__c=oppName);
            accList.add(acc);
        }
        if(accList.size() > 0){
            update accList;
        }
    }
Delete and insert is working fine but I am not getting why my update is not working please check this code 
Arun Kumar 1141Arun Kumar 1141
Hi Paul H 5,

Please find below the updated code : 

Trigger :  
trigger OpportunityTrigger on Opportunity (after insert, after update, after delete, after undelete) {

    if(trigger.isAfter){
        if(trigger.isInsert || trigger.isUpdate || trigger.isUndelete){
            OpportunityTriggerHandler.updateAccWithHighestOpportunityAmount(trigger.new);
        }
        if(trigger.isDelete){
            OpportunityTriggerHandler.updateAccWithHighestOpportunityAmount(trigger.old);
        }
    }
}

Handler Class :
  
public class OpportunityTriggerHandler {

    public static void updateAccWithHighestOpportunityAmount(List<Opportunity> oppList){
       
        Set<Id> accIds = new Set<Id>();
        
        for(Opportunity opp: oppList){
            accIds.add(opp.AccountId);
        }
        
        List<AggregateResult> agList = [Select Name name, AccountId accId, MAX(Amount) maxAmt from Opportunity
                                          where Amount!=null and AccountId IN: accIds
                                          group by Name, AccountId ORDER BY MAX(Amount) desc limit 1];
        
        List<Account> accList = [Select id, name from Account where id =: accIds];
        
        List<Account> updatedAccList = new List<Account>();
        
       
        for(AggregateResult ag: agList){
            for(Account acc: accList){
                if(acc.Id == (String)ag.get('accId')){
                    acc.HighestOppAmount__c = (String)ag.get('name');
                    updatedAccList.add(acc);
                }
            }  
        }
        update updatedAccList;
        
    }
}

Hope it is helpful.

Thanks.