What is SOQL (Salesforce Object Query Language)?
Salesforce Object Query Language. It is used to retrieve data from the Salesforce database according to the specified conditions and objects. Similar to all Apex code, SOQL is also case insensitive.
When to use SOQL?
Use SOQL when you know which objects the data resides in, and you want to:
- Retrieve data from a single object or from multiple objects that are related to one another.
- Count the number of records that meet the specified criteria.
- Sort results as part of the query.
- Retrieve data from number, date, or checkbox fields.