Difference between SOQL & SOSL

By


SOQL
SOSL
Salesforce object query language
Salesforce object search language
It is used to retrieve records from salesforce org’s object.
SOSL do text-based searching in salesforce orgs.
In SOQL object is necessary.
In SOSL object is not necessary.
Select statement is used.
Find keyword is used.
Id is by default returned by SOQL statement.
SOSL returns by default id’s of matched records.
SELECT Id, Name FROM Account WHERE Name = 'Acme'
FIND {Joe Smith} IN Name Fields RETURNING lead (name, phone)
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 object.
We can query on multiple objects.

Governer Limit: 
  1. Total number of SOQL queries issued 100 (Synchronously)
  2. Total number of SOQL queries issued for Batch Apex and future methods 200 (Asynchronously)
  3. Total number of records retrieved by SOQL queries 50,000
  4. Total number of records retrieved by Database.getQueryLocator 10,000
  5. Total number of SOSL queries issued 20
  6. Total number of records retrieved by a single SOSL query 200

Comments

Post a Comment

Popular posts from this blog

Database Methods

By
Image
Database Methods Apex contains the built-in Database class, which provides methods that perform DML operations and mirror the DML statement counterparts. These Database methods are static and are called on the class name. Database.insert() Database.update() Database.upsert() Database.delete() Database.undelete() Database.merge() Unlike DML statements, Database methods have an optional allOrNone parameter that allows you to specify whether the operation should partially succeed. When this parameter is set to false , if errors occur on a partial set of records, the successful records will be committed and errors will be returned for the failed records. Also, no exceptions are thrown with the partial success option. This is how you call the insert method with the allOrNone set to false . Database.insert(recordList, false); The Database methods return result objects containing success or failure information for each record. For example, insert and update...
Read more

Salesforce Admin Basic Questions and Answers

By
FIEL DS & FIELD TYPES What are the different field types available in Salesforce? Text, Number, Currency, Date, Date/Time, Percent, Picklist, Multi-Select Picklist, Checkbox, Email, Phone, URL, Text Area, Long Text Area, Rich Text Area, Auto Number, Formula, Roll-Up Summary, Geolocation. What is the difference between a standard field and a custom field? Standard fields are provided by Salesforce by default. Custom fields are created by users as per business needs. What is a formula field? Can you give an example? A formula field calculates values using other fields. Example: A formula field showing Total Price = Quantity * Unit Price. What is a roll-up summary field? On which relationship can you create it? It calculates values (SUM, MIN, MAX, COUNT) from child records. I t can only be created on Master-Detail relationships. What is an auto-number field? Where have you used it? It auto-generates a unique number for each record. Used in objects like Invoice, Order, Case for trackin...
Read more

Salesforce Licenses

By
Image
For Developer Edition: User Licenses (A user license determines the baseline of features that the user can access.) Name Total License Salesforce 2 Salesforce Platform 3 Customer Community Login 5 XOrg Proxy User 2 Work.com Only 3 Customer Portal Manager Custom 5 Identity 10 Customer Community Plus 5 Silver Partner 2 Gold Partner 3 Customer Portal Manager Standard           5 Force.com App Subscription 2 Customer Community Plus Login 5 Partner App Subscription 2 External Identity 5 Partner Community 5 Partner Community Login 5 Customer Community 5 Force.com – Free 2 Chatter Free 5000 Chatter External 500 High Volume Customer Portal 10...
Read more