- April 30, 2016 at 8:29 am #10803Shubham #9
What is the difference between SOQL and SOSL?
What is the difference between SOQL and SOSL? Can somebody explain with a simple example.April 30, 2016 at 8:56 am #10813Nitish #224
Here is this:-
- SOQL Statements
SOQL statements evaluate to a list of sObjects, a single sObject, or an Integer for count method queries.
For example, you could retrieve a list of accounts that are named Acme:
List<Account> aa = [SELECT Id, Name FROM Account WHERE Name = ‘Acme’];
2. SOSL Statements
SOSL statements evaluate to a list of lists of sObjects, where each list contains the search results for a particular sObject type. The result lists are always returned in the same order as they were specified in the SOSL query. If a SOSL query does not return any records for a specified sObject type, the search results include an empty list for that sObject.
For example, you can return a list of accounts, contacts, opportunities, and leads that begin with the phrase map:
List<List<SObject>> searchList = [FIND ‘map*’ IN ALL FIELDS RETURNING Account (Id, Name), Contact, Opportunity, Lead];April 30, 2016 at 9:31 am #10824Ravi #173
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.
- SOQL Statements
Please Register to reply to this topic. /