Level: IntermediateSalesforce
Dynamic SOQL in Apex and How to Prevent SOQL Injection
Dynamic SOQL in Apex lets you build a query as a text string while the code runs, then execute it. This is useful when…
Tag
SOQL
Level: IntermediateSalesforce
SOQL Date Literals and Bind Variables in Apex
SOQL Date Literals are ready-made words, such as TODAY or LAST_N_DAYS:30, that stand for a date range in a query. Bind variables let you…
Level: IntermediateSalesforce
SOQL Aggregate Functions and GROUP BY in Apex
SOQL Aggregate Functions calculate totals, averages, counts and other summary values directly in the database. Instead of loading 5,000 records and adding fees in…
Level: IntermediateSalesforce
SOQL Relationship Queries: Parent and Child Records in Apex
SOQL Relationship Queries let you read related records in one query, such as each enrolment with its course name, or each course with all…
Level: IntermediateSalesforce
SOQL WHERE Clause, ORDER BY, LIMIT and OFFSET in Apex
The SOQL WHERE Clause decides which records your query returns. ORDER BY decides their order, LIMIT decides how many come back, and OFFSET skips…
Level: IntermediateSalesforce
SOQL Basics: Write Your First Query in Apex
SOQL Basics are the first skill you need to read Salesforce data inside Apex code. SOQL stands for Salesforce Object Query Language. It lets…