Salesforce Fact #946 | Constructing dynamic SOQL using dynamic formula evaluation

With Summer'25 release, Dynamic formula evaluation is possible using FormulaBuilder.parseAsTemplate() method and merge field syntax.

This approach can be used to construct Dynamic SOQL queries.

In this example, we are trying to fetch Account records which are matching with a Lead ownerid and Leadsource.

Reference: https://developer.salesforce.com/blogs/2025/05/summer25-developers

Attached is the screenshot.



Comments

Post a Comment

Popular posts from this blog

Salesforce Fact #913 | Access selected record field values in screen flow lookup w/o Get Records

Image
Suppose we are using the Lookup element in the screen flow and once a record is selected, we would like to get the value from other fields. Now, Lookup provides record Id and record Name field values by default. So in order to get the other field value we need to use a Get Records. But hold on! There is an option to get the field values without using a Get Records element. We need to define a child sobject variable and then in the advanced section, set the parent field Id with the record Id of the selected record in Lookup. In this example, we have a lookup of Account record and we are using a Contact record variable and setting the AccountId field with the selected record Id and later on accessing the field values from account. Attached are the screenshots.
Read more