Activity Forums Salesforce® Discussions Differentiate between Salesforce Object Query Language and Salesforce Object Search Language?

  • Differentiate between Salesforce Object Query Language and Salesforce Object Search Language?

    Posted by Laveena on August 26, 2019 at 11:20 am

    Differentiate between Salesforce Object Query Language and Salesforce Object Search Language?

    Yogesh replied 4 years, 8 months ago 2 Members · 1 Reply
  • 1 Reply
  • Yogesh

    Member
    August 26, 2019 at 11:36 am

    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.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos