Salesforce Fact #847 | SOQL INCLUDES with collection

While using SOQL INCLUDES operator with collection, it doesn't support bind expressions.

So, the input collection is to be converted to string format and we need to use dynamic SOQL.

Reference: https://salesforce.stackexchange.com/questions/314035/using-collections-in-soql-includes

Attached is one sample 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