1. SOQL: Salesforce Object Query Language
- SOQL: Salesforce Object Query Language
- SOQL Purpose: To fetch info. from an object and related objects.
- We can write query on one object while querying on those objects we can fetch the child object info. or parent object info. (we cannot capture un related objects info.)
- SOQL queries per transaction: 100.
- SOQL query rows returned: 50000.
2. SOSL: Salesforce Object Search Language
- SOSL: Salesforce Object Search Language.
- SOSL Purpose:We can search for a value in multiple objects (no need of any relationship).
- Results of SOSL query can be stored in List of List.
- SOSL queries per transaction: 20.
- SOSL query rows returned: 2000.