What is difference between SOQL and SOSL?

What is difference between SOQL and SOSL?

SOQL	SOSL
SOQL (Salesforce Object Query Language ) retrieves the records from the database by using “SELECT” keyword.	SOSL(Salesforce Object Search Language) retrieves the records from the database by using the “FIND” keyword.
By Using SOQL we can know in Which objects or fields the data resides.	By using SOSL, we don’t know in which object or field the data resides.
We can retrieve data from single object or from multiple objects that are related to each other.	We can retrieve multiple objects and field values efficiently when the objects may or may not be related to each other.
We can Query on only one table.	We can query on multiple tables.

Read more »

What is SOSL in Apex?

What is SOSL in Apex?

Salesforce Object Search Language (SOSL) is a simple language for searching across all multiple persisted objects simultaneously.

1. Sosl statements evaluate to a list of SObjects where each list contains the search results for a particular sobject type.
2. SOSL queries are only supported in apex classes and anonymous blocks.
3. We can not use a SOSL query in trigger.

EX:-

The following example that searches all fields across all account and contact objects.

List<List< Sobject>> searchList = [FIND ‘Text*’  IN ALL FIELDS RETURNING Account,Contact];

system.debug(‘searchlist is :’+searchList );

Ex2 : - The Example shows the data with test in Accounts,Contacts,Leads,Oppotunities with Vf page.

Vf  Page :-

<apex:page controller="DeferenceDemoController">

 <apex:form >

    <apex:commandButton value="Show records using SOSL" action="{!soslDemo_method}"/>

    <apex:pageBlock title="Accounts">

      <apex:pageblockTable value="{!accList }" var="acc">

         <apex:column value="{!acc.name}"/>

         <apex:column value="{!acc.Type}"/>

      </apex:pageblockTable>

    </apex:pageBlock>

<apex:pageBlock title="Contacts">

    <apex:pageblockTable value="{!conList}" var="con">

     <apex:column value="{!con.name}"/>

     <apex:column value="{!con.email}"/>

</apex:pageblockTable>

</apex:pageBlock>

<apex:pageBlock title="Leads">

    <apex:pageblockTable value="{!leaList}" var="lea">

     <apex:column value="{!lea.name}"/>

     <apex:column value="{!lea.company}"/>

    </apex:pageblockTable>

</apex:pageBlock>

<apex:pageBlock title="Opportunities">

    <apex:pageblockTable value="{!optyList}" var="opty">

     <apex:column value="{!opty.name}"/>

    <apex:column value="{!opty.StageName}"/>

</apex:pageblockTable>

</apex:pageBlock>

 </apex:form>

</apex:page>

Apex Controller :-

Public with sharing class DeferenceDemoController {

Public List<Opportunity> optyList {get;set;}

Public List<Lead> leaList{get;set;}

Public List<contact> conList{get;set;}

Public List<account> accList{get;set;}

  Public DeferenceDemoController(){

  }

 Public void soslDemo_method(){

  optyList = New List<Opportunity>();

  leaList = New List<Lead>();

  conList = New List<contact>();

  accList = New List<account>();

  List<List <sObject>> searchList = [FIND 'test' IN ALL FIELDS RETURNING  Account (Id,Name,type),Contact(name,email),Opportunity(name,StageName),Lead(company,name,status) ];

  accList = ((List<Account>)searchList[0]);

  conList  = ((List<contact>)searchList[1]);

  optyList = ((List<Opportunity>)searchList[2]);

  leaList  = ((List<Lead>)searchList[3]);

 }

}

Read more »