Salesforce Fact #712 | Dynamic SOQL with multiple AND filters

Suppose we need to construct an SOQL so that it contains multiple AND conditions based on the multiple filter values passed. If a particular filter value is passed only then it will be considered.

We can have an apex method to construct the dynamic SOQL considering the possible scenarios.

Attached are the screenshots.




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