Skip to main content

Method to retrieve correct ID from formula field.

One idea that really helpful to be delivered. Please vote
Reduce the compiled formula character cost of CASESAFEID()

Correct way to store ID in formula

Formula field only return 15 char ID and will be treated as String / Text . Which mean it will be treated as case insensitive in SOQL.

SELECT Id,Name,Parent.Id, Parent.Name, Ultimate_Parent_Account_ID1__c FROM Account WHERE Ultimate_Parent_Account_ID1__c ='001xxxxxxxxxQpK'

Will return record regardless the letter case
And also another  risk if  we query this with 18 digit ID as it will return 0 data.

As conclusion, normal formula with text return type is not able to capture the Salesforce Id correctly. 
In order to make it return as ID use CASESAFEID() . However this formula consumes so much character so that is the reason why you need to vote above idea.

Retrieve the correct Id from formula in Apex

If we are not able to use casesafeid in formula field , then we might need to be careful when retrieve record using formula field because SOQL is case-insensitve and ID is case sensitive. Honestly I wish that Salesforce provides a function that I can use directly in SOQL something like this ‘where casesafeid(Ultimate_Parent_Account_ID1__c) = ='001xxxxxxxxxQpKAAU' but unfortunately it is not available for this time being.

In order to ensure the Id is correct , we need to cast it to Id .Please note that I cast String to ID :
 Id ultimateid = (ID)account.Ultimate_Parent_Account_ID1__c . 

With this I can use the actual Id for further processing.

String accountId15Char = '001xxxxxxxxxQpK';//because it will not entertain Id type or 18 character
Map<Id,Account> mapUltimateAccount =new Map<Id,Account>
                                      ([Select Id ,Parent.Id,Parent.Name  ,Ultimate_Parent_Account_ID1__c from Account where
         system.debug('@@@ mapUltimateAccount ' + mapUltimateAccount.size());
        //ultimate id contains complete hierarchy 
        //and exclude the account itself should be more than 1
            for(Id accountId :mapUltimateAccount.keySet()){
               Account account =mapUltimateAccount.get(accountId);
               Id ultimateid = (ID)account.Ultimate_Parent_Account_ID1__c ;
               system.debug('Original Ultimate Id ' + account.Ultimate_Parent_Account_ID1__c+ ' , after convert to Id '+ ultimateid);
      //here you can have mechanism to compare id whether it returns the correct id

I think that's it for today. See you in next entry.


Popular posts from this blog

Search Solution Basics

When is it a good time to create a customized search solution? You're developing an external knowledge base for user support. You're in the mood for a fun Friday night. The sales reps just started using the Sales Cloud in Lightning Experience. You want to put your company branding in the search bar. What differentiates SOSL from SOQL? Syntax SOSL searches the search index instead of the org database. SOSL searches more efficiently when you don't know in which object the data resides. All of the above. SOSL works with: REST only SOAP only REST, SOAP, and Apex SOQL only What does a search for a single object look like in SOSL? FIND {cloud} RETURNING Account FIND in ACCOUNT RETURNING "cloud" FIND "cloud" in ACCOUNT FIND (cloud) RIGHT NOW! What does a search for multiple objects look like in SOSL? FIND {sneakers} RETURNING ALL ARTICLES FIND {sneakers} in ALL OBJECTS FIND {sneakers} RETURNING Product2, Content

Process Builder is not fired when field update is called from Approval Process

Scenario In Final Approvals section ; in Approval Process we have field update to update Status field. In Process Builder , we have some action that need to be done when Status field is updated in Approval Process.However this process builder is not fired. Solution To handle this, in Field Update in Approval Process , check Re-evaluated Workflow Rules after Field Change as picture below. What happen if field updated from Approval Process. Workflow - does not fires untill Re-evaluate workflow checkbox is ticked on your field update Process Builder - does not fires untill Re-evaluate workflow checkbox is ticked on your field update Trigger - will fire if conditions are matched This is explained in article here  . Field Updates That Re-evaluate Workflow Rules If  Re-evaluate Workflow Rules After Field Change  is enabled for a field update action, Salesforce  re-evaluates all workflow rules on the object if the field update results in a change to the value of the fi

Tips and Tricks : Test class for Invocable method

Issue : I got 100% coverage in my sandbox but when run validation for deployment it returns 0% coverage It turn out that in my sandbox, I am depending on Process Builder to Invocable Apex class, as long I manipulate test data that fire Process Builder it will call Invocable class. This is not useful when deploying it to Production although it gets deployed together with Process Builder. The correct way is to direct call Invocable method inside test class itself. Example of class : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 global class MyCustomObject_StatusUpdate_Util { @InvocableMethod ( label = ' Update Quote Status ' ) public static void updateQuote ( Request [] requests ) { Set < Id > setOppId = new Set < Id >(); List < SBQQ__Quote__c > listQuoteToUpdate = new List < SBQQ__Quote__c >(); for ( Request request : requests ) {