-
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
-
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.
Popular Salesforce Blogs
How Can Customizing Salesforce Help Non-Profit Organizations?
Salesforce can support every industry sector, helping companies earn more profits and achieve business growth. But what about the non-profit sector? The good thing is…
Transforming Customer Experience: Why Businesses Need a Salesforce Customer Portal in 2025
Customer experience (CX) is the actual competitive advantage in 2025. Customers demand immediate service, customized service, and convenience based on digital-first at all touchpoints. These…
Salesforce Visual Composer – Populate any PDF with Salesforce Data
There are many uses case that will require your customer to manually sign a Document, few examples are: NDA, Contract or Power of Attorney. In…
Popular Salesforce Videos
How Big Was Salesforce Dreamforce 21 Park? Take a Walk.
This two-minute walk shows exactly how Salesforce Dreamforce 21 International Park was set up. See for yourself how big it is. Also, share your Dreamforce…
Creating a Rollup Using DLRS | Salesforce Tutorial
In certain situations, an object does not support a roll-up, or the relationship is not permitted. Learn how to make it possible by using the…
All Things Telesales Podcast
Sales Director at Natterbox, Ian Moyse shares with us 3 Powerful Pillars of Servant Leadership - Yearning, Earning, Learning. Ian drops wisdom bombs left and right…
