Skip to main content

How to define generic null check of fields ?

 Use Case : Lets say you have a requirement to copy modified field values from latest opportunity to Account , then how can you do field mapping effectively ? 

Assumptions: We are not using any flows here. 

Step - 1 Get all Account Ids from Opportunity Trigger/trigger helper

Step -2 Query Account and Its related opportunity records, assume you want to define latest opportunity by LastStageChangeDate, you can use createdDate too. This will give account details and latest opportunity without the new values that has been modified. so this is basically old opportunity. 

private static List<Account> getAccounts(set<id> accountIdset){
    return [SELECT id,Field_1__c,Field_2__c,Field_3__c,Field_4__c,PersonEmail,Phone,
                               
            (SELECT id,Field_1__c,Field_2__c,Field_3__c,Field_4__c, Email__c,Phone__c
            FROM opportunities
            WHERE stagename = 'Admit' OR stagename = 'Return From Hospital'
            ORDER BY laststagechangeDate DESC LIMIT 1)
            FROM Account where Id IN: accountIdset WITH User_Mode];
}

Step - 3 Create a Map key as AccountId and value as Opportunity from trigger helper. This opportunity will be considered as new opportunity.

Step - 4 Iterate over Account records, under account list there will be another loop to iterate opportunity but that will be one record. when old opportunity Id and new opportunity id same that means latest opportunity is modified. Will leave up to you to find latest records. Now comes field mapping

Step - 5 Field Mapping 

 if(oldOppy.Id == newOppy.Id){
    if(newOppy.Field_1__c !=null){
        account.Field_1__c = newOppy.Field_1__c ;
    }
    if(newOppy.Field_2__c !=null){
        account.Field_2__c = newOppy.Field_2__c ;
    }
    if(newOppy.Field_3__c !=null){
        account.Field_3__c = newOppy.Field_3__c ;
    }
    if(newOppy.Field_4__c !=null){
        account.Field_4__c = newOppy.Field_4__c ;
    }

 } 

If you have few fields, then it is ok, if you need to map 100 fields then 100 ifs need to written, this is code redundancy, What if you need to get values from other object say Case then ?

So Instead of writing multiple Ifs , we can have one generic utility method that will work across object and field. 

Here is generic method 

 public Static void updateFieldIfNotNull(SObject record, String fieldName, Object fieldValue){
    if (fieldValue != null) {
            record.put(fieldName, fieldValue);
     }
       
}

Calling generic method.
 if(oldOppy.Id == newOppy.Id){
    updateFieldIfNotNull(acc,'Field_1__c',newOppy.Field_1__c);
    updateFieldIfNotNull(acc,'Field_2__c',newOppy.Field_2__c);
    updateFieldIfNotNull(acc,'Field_3__c',newOppy.Field_3__c);
    updateFieldIfNotNull(acc,'Field_4__c',newOppy.Field_4__c);
   
 }
Now code is short and readable.
Please try this approach and let me know in comments if this is useful for you.
Keep Learning !!


Labels:

Comments

Post a Comment

Popular posts from this blog

How to Create a Tooltip in Lightning Datatable ?

Imagine you have a datatable displaying a list of Contact records , and one of the columns shows the Account Name . The Account Name is a hyperlink that allows users to navigate to the Account record page. But what if users want to take a quick glance at some key Account fields —like Phone or Address—without navigating to the Account record? In Salesforce Classic, this was achieved using the Mini Page Layout feature from standard page. However, in Lightning Experience, we can implement a similar feature by adding a tooltip to the data table. Solution Overview: We’ll create a Lightning Web Component (LWC) that: Displays a data table with a clickable Account Name . Provides a tooltip that shows the Account's Phone and Address fields when users hover over the Account Name. Implementation Steps: 1. Data Preparation We need to retrieve the following fields for each Contact and its associated Account: Contact Fields : Name, Phone, Email Account Fields : Name, Phone, Billing Addre...
Post a Comment
Read more

How to Create/Delete file attachments(Content Document) through Apex ?

 There are 3 standard salesforce objects to store file attachments. Content Document, ContentDocumentVersion, ContentDocumentLink.  Here is the article to talk about these objects and relationship.  https://www.forcetalks.com/blog/contentdocument-and-contentversion-in-salesforce-an-overview/ ContentDocumentVersion ContentDocumentLink This post is all about how to create/delete content document though Apex. Here is code snippet // Insert Content Version record ContentVersion contentVersionRec = new ContentVersion(Title='filename',PathOnClient ='FileName.pdf',VersionData = bodyBlob,origin = 'H'); INSERT contentVersionRec; // this will insert one record in ContentDocument and ContentVersion , ContentDocument  is parent and  ContentVersion is child record // get contentdocument id contentVersionRec = [SELECT Id, Title, ContentDocumentId FROM ContentVersion WHERE Id = :contentVersionRec .Id LIMIT 1]; // Create Content Document Link record- This will attach ...
Post a Comment
Read more

Lifecycle hooks in LWC

There are 3 phase of LWC component  1. Mounting  A. constructor, B. connnectedCallback C. render D. renderedCallback 2. UnMounting  A. disconnectedcallback 3. Error  A.errorcallback Note - render is not lifecycle hook, it is protected method of Lightning element class. Mounting Phase LWC Creation and Render Life cycle Constructor Method ·        This method called when component is instantiated and It flows from parent to child component. ·        Need to call Super() inside constructor method ·        Can’t access any component properties or child component because it’s not ready yet. ·        Host element can be accessed through “this. template” inside constructor method. ·        Don’t add any attributes to host inside constructor C   constructor (){          super (); //...
Post a Comment
Read more