-
What is the difference between SOQL and SOSL in Salesforce?
What is the difference between SOQL and SOSL in Salesforce?
-
2 Replies
-
The differences are mentioned in the table below:
SOQL vs SOSL
SOQL (Salesforce Object Query Language)
Only one object can be searched at a time
Can query any type of field
Can be used in classes and triggers
DML Operation can be performed on query results
Returns records
SOSL (Salesforce Object Search Language)
Many objects can be searched at a time
Can query only on email, text or phone
Can be used in classes, but not triggers
DML Operation cannot be performed on search results
Returns fields
-
SOQL:
1) SOQL (Salesforce Object Query Language ) retrieves the records from the database by using “SELECT” keyword.
2) By Using SOQL we can know in Which objects or fields the data resides.
3) We can retrieve data from single object or from multiple objects that are related to each other.
4) We can Query on only one table.SOSL:
1) SOSL(Salesforce Object Search Language) retrieves the records from the database by using the “FIND” keyword.
2) By using SOSL, we don’t know in which object or field the data resides.
3) We can retrieve multiple objects and field values efficiently when the objects may or may not be related to each other.
4) We can query on multiple tables.Thanks
Log In to reply.
Popular Salesforce Blogs
Adopt Visualforce with new Lightning Experience
None of us are anymore oblivious of the fact that Salesforce Lightning Experience is a modern, productive user experience designed to multiply the efficiency manifold.…
No Code Clearbit and Salesforce Integration
Clearbit is a consumer contact marketing data engine. It assists businesses in expanding by delivering solutions that enable them to better understand their clients, discover…
Understanding Workflow Rules in Salesforce | The Developer Guide
Work process in Salesforce is essentially a holder or business rationale motor that computerized certain activities dependent on specific rules. On the off chance that…
Popular Salesforce Videos
Prepopulate Field values in Salesforce Lightning Experience Using defaultFieldValues
Prepopulate Field values in Lightning Experience Using defaultFieldValues - Spring 20 This video demonstrates the following items: Set Record Type Id Using defaultFieldValues Enforce User…
Marc Benioff & Aneel Bhusri On Ensuring a Safe Return to Work | Leading Through Change | Salesforce
In this week’s Leading Through Change, join Aneel Bhusri the Co-Founder and CEO of Workday and Marc Benioff the Chair and CEO of Salesforce as…
Data Import: Clean and Prepare Your Data Using Excel | Salesforce
Cleaning and Preparing Data Using Excel covers several features and functions that will make quick work of getting your data files ready for import. Vlookup,…
