SOQL vs SOSL explaination

-
SOQL vs SOSL explaination:-
SOSL(Salesforce object search language) simplified :-
Facebook graph search is much-a-like SOSL, After searching something you can see results returned from name,post, pages which in turn like returning a List of list of sObjects.
SOQL(Salesforce object query language) simplified :-
SOQL is like searching your Facebook friend list which in turn like returning a List of sObjects.
Tabular comparison :-
SOQL
SOSL
Data retrieval done via using ‘SELECT’ keyword
Data retrieval done via using ‘FIND’ keyword
Data retrieval from single object plus related objects
Data retrieval from multiple objects.
Much-a-like querying on single table
Much-a-like querying on Multiple table
SOQL and SOSL generally have the same limitations
SOQL and SOSL generally have the same limitations
Governor Limits on SOQL and SOSL :-
SOQL Limits ->
Total number of SOQL queries issued in synchronous mode is 100, where in asynchronous mode it is 200,  records retrieved by SOQL queries is 50,000.
SOSL Limits ->
Total number of SOQL queries issued is 20, records retrieved by SOQL queries is 2,000.

Comments

Post a Comment

Popular posts from this blog

Set Field-Level Security for a Field on Permission Sets Instead of Profiles (Generally Available)

-
Image
  When you create a field, set its field-level security on permission sets instead of profiles. Or, modify the field-level security for an existing field for all permission sets in Object Manager. This change makes it easier to follow the user access control best practice of using permission sets to manage your users’ permissions rather than profiles. This feature, now generally available, includes an enhancement so that you can see each permission set’s object permissions for the field’s object without leaving the page. Where:  This change applies to Lightning Experience and Salesforce Classic in all editions. How:  From Setup, in the Quick Find box, enter  User Management Settings , and then select  User Management Settings . Enable  Field-Level Security for Permission Sets During Field Creation . Now, when you create a field, set field-level security on an existing field, or change a custom field’s type, you assign field-level security for permission set...
Read more

Einstein GPT - Generative Responses : Summer'23 Salesforce Release

-
Image
                                                         Einstein GPT innovations Customer Need Agents need a faster way to reply to customer questions and want to spend their time adding value to the conversation, rather than writing or repeating the same response across customers. Solution / How To Configure Configure Messaging for In-app and Web and Einstein GPT Reply Recommendation component. Use Case Automatically generate/suggest responses to assist agents in a Messaging conversation with a customer. Impact Reduce Average Handle Time Increase CSAT
Read more

Program Assignment Invocable Action : Summer'23 Salesforce Release

-
Image
                                   Invocable Action in Flow to dynamically assign Programs Customer Need Assign Enablement Users to Enablement Programs based on any criteria supported in Flow. Solution / How To Configure Users with the Manage Flows permissions can create “assign enablement program” actions in Flow builder . Use Case Automatically assign reps to Enablement onboarding programs based on their inclusion in a new group, account, opportunity. Impact User productivity
Read more