Skip to main content


Showing posts from August, 2019

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 re

Soap UI fail to handshake with Salesforce

I faced this when doing Salesforce Trailhead : SOAP API Unit  , it has nothing to do with token or password but something to do with TLS version. The solution can be referred here but I will re-write back how I solved this. Note that I am using Windows 10 and SoapUI 5.3.0 . Navigate to your SoapUI folder where it should be something  C:\Program Files (x86)\SmartBear\SoapUI-5.3.0\bin . Notice there .vmoptions file. Open that file and paste this - Dsoapui . https . protocols = SSLv3 , TLSv1 . 2 So it end result will look like this . -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -Xms128m -Xmx1000m -Dsoapui.https.protocols=SSLv3,TLSv1.2 -Dsoapui.home=C:\Program Files (x86)\SmartBear\SoapUI-5.3.0/bin -Dsoapui.ext.libraries=C:\Program Files (x86)\SmartBear\SoapUI-5.3.0/bin/ext -Dsoapui.ext.listeners=C:\Program Files (x86)\SmartBear\SoapUI-5.3.0/bin/listeners -Dsoapui.ext.actions=C:\Program Files (x86)\SmartBear\SoapUI-5.3.0/bin/