-
How can we compare the multiple record fetch from soql query to each other?
Hi All,
How can we compare the multiple record fetch from soql query to each other?
I am in situation in which I want that result obtain from different SOQL query can be compare to one another.
Please give suggestion
-
2 Replies
-
Hi Mohit,
You can use aggregate functions here. Use field in Group By for criteria of comparison.
Thanks
- [adinserter block='9']
-
Hello Mohit,
Salesforce does not allow direct field to field comparison in SOQL query.
To achieve this you may create a formula field that will compare fields and return a value (like true or false) which you may use in a WHERE clause.
So for the above query, you could create a formula field on User object with return type Text e.g. NameCompare, with the formula
IF(User.FirstName != User.LastName, ‘true’, ‘false’)
Log In to reply.
