Skip to main content

How to retrieve populated fields from a sObject ?

 As part of summer 16, the sObject method getPopulatedFieldsAsMap() was released. This method will return a map of populated field names and their corresponding values. The map contains only the fields that have been populated in memory for the SObject instance.

https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_methods_system_sobject.htm#apex_System_SObject_getPopulatedFieldsAsMap

Here are certain use cases to  this method.

1.  Fields are queried in the SOQL Statement

Account acc = [SELECT id,name,phone,Gender__pc From Account
               WHERE id = '0011F00000zJIvwQAG'];
System.debug('acc->'+acc);
Map<String, Object> accMap = acc.getPopulatedFieldsAsMap();
system.debug('Fields name-->'+accMap.keySet());
for (String fieldName : accMap.keySet()){
    System.debug('field name is ' + fieldName + ', value is ' + 
        accMap.get(fieldName));

}
OutPut -
Note - Id, and Recodtype will come by default even if it is not added in Query.
We can also use dynamic query for this.

public static void getPopulatedFields(List<String> fields, String objName) {
    String soql = ' Select ' + String.join(fields, ',') + 
                  ' From ' + objName;
    
    for (sObject obj : Database.query(soql)) {
       Map<String, Object> fieldValues = obj.getPopulatedFieldsAsMap();
       for (String fieldName : fieldValues.keySet()) {
           System.debug(fieldName + '=' + fieldValues.get(fieldName));
       }
    } 
}
// Invoking method
List<String> fields = new List<String>{'Name','Phone','Gender__pc'};
getPopulatedFields(fields, 'Account');

2. Fields are explicitly set before calling the getPopulatedFieldsAsMap() method.
Account acc = new Account(Name='Test Acc',Phone='1122334565');
//sert acc;
Map<String, Object> accMap = acc.getPopulatedFieldsAsMap();
system.debug('Fields name-->'+accMap.keySet());
for (String fieldName : accMap.keySet()){
    System.debug('field name is ' + fieldName + ', value is ' + 
        accMap.get(fieldName));

}
OutPut -

3. Using Relationship Query. Child to parent.

Account acc = [SELECT id,name,phone,Gender__pc,owner.Name,Createdby.Email,
SHC_Facility__pr.Facility_Short_Name__c,(Select CaseNumber, Status From Cases)  
               FROM Account
               WHERE id = '0011F00000zJIvwQAG'];
Map<String, Object> accMap = acc.getPopulatedFieldsAsMap();
system.debug('Fields name-->'+accMap.keySet());
It will print -
13:50:17:036 USER_DEBUG [6]|DEBUG|Fields name-->
{CreatedBy, CreatedById, Gender__pc, Id, Name, Owner, OwnerId, Phone, RecordTypeId,
SHC_Facility__pc, ...}
How will we get fields of related objects such as Owner or CreatedBy or
SHC_facility__pr

User uRec = (User)accMap.get('Owner'); Map<String, Object> userMap = uRec.getPopulatedFieldsAsMap(); system.debug('Owner Fields name-->'+userMap.keySet()); User createdByRec = (User)accMap.get('CreatedBy'); Map<String, Object> CreateduserMap = createdByRec.getPopulatedFieldsAsMap(); system.debug('Created By Fields name-->'+CreateduserMap.keySet()); Rehabilitation_Center__c facility = (Rehabilitation_Center__c)accMap.get('SHC_Facility__pr'); Map<String, Object> FaciLityMap = facility.getPopulatedFieldsAsMap(); system.debug('FaciLityMap Fields name-->'+FaciLityMap.keySet());

// To get case record fields and value
List<Case> caseList = (List<Case>)accMap.get('Cases');
System.debug('caseList--'+caseList);
Map<String, Object> caseMap = caseList[0].getPopulatedFieldsAsMap();
System.debug('caseMap-fields-'+caseMap.keySet());

To know value we need to iterate over map keyset and get value.

We can also write generic code which will support all objects.
/* method to expand map of key to find out parent or child objects and get value 
and field name after
*/
public void getPopulatedFields(Map<String, Object> fieldValues) {
   for (String fieldName : fieldValues.keySet()) {
       if (fieldValues.get(fieldName) instanceof List<sObject>) {
           System.debug('------Begin Child------');
           getPopulatedFields((List<sObject>) fieldValues.get(fieldName));
           System.debug('------End Child------');
       } else if (fieldValues.get(fieldName) instanceof sObject) {
           System.debug('------Begin Parent------');
           sObject obj = (sObject) fieldValues.get(fieldName);
           getPopulatedFields(obj.getPopulatedFieldsAsMap());
           System.debug('------End Parent------');
       } else {
           System.debug(fieldName + '=' + fieldValues.get(fieldName));
       }
   }
}
/* method to iterarte over child recordList and call getPopulatedFields passing result
 of getPopulatedFieldsAsMap
*/
public void getPopulatedFields(List<sObject> objs) {
   for (sObject obj : objs) {
        getPopulatedFields(obj.getPopulatedFieldsAsMap());
    }
}

/* method will accept object name and fields name, get records by using dynamic query
 and call getPopulatedFields
*/
public void getPopulatedFields(List<String> fields, String objName) {
    String soql = ' Select ' + String.join(fields, ',') + 
                  ' From ' + objName;

    List<sObject> objs = Database.query(soql);
    getPopulatedFields(objs);
}

Invoking methods.
List<String> fields = new List<String>
{'Name,phone,Gender__pc,owner.Name,Createdby.Email,
SHC_Facility__pr.Facility_Short_Name__c, (Select CaseNumber, Status From Cases)'};
getPopulatedFields(fields,'Account')

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