SOQLRecipes

---

layout: default

SOQLRecipes class

Demonstrates how to make various types of SOQL calls including multi-object queries, and aggregate queries

Related

CanTheUser

---

Methods

getAccountRecordsInState(String state) → List<Account>

Demonstrates how to use a bound variable in a WHERE clause

Parameters

Param	Description
state	String representing a US State code (AK, KS, etc.)

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getAccountRecordsInState('ks'));

getChunksOfLargeNumbersOfRecords() → Integer[]

One of the little known features of SOQL for loops is that you can iterate not only over each record returned by the query, but also over each chunk of records. As the code below demonstrates, specifying the iteration variable as a list/array will return 200 record chunks from the query, rather than individual records. Note: Normally, if you're only dealing with counts of records, you'd utilize the Count() soql method, but in this case we're demonstrating that this form of a soql for loop gives you access both to a list of records, and to the records themselves.

Return

Type

Integer[]

Description

Integer

getDetailsFromBothParentRecords() → List<Junction__c>

Demonstrates how to write a query that pulls information from two parent objects through a junction object

Return

Type

List<Junction__c>

Description

List<Junction__c>

Example

System.debug(SOQLRecipes.getDetailsFromBothParentRecords());

getFirstXRecords(Integer wantedNumberOfRows) → List<Account>

Demonstrates how to use a bound variable to define the LIMIT

Parameters

Param	Description
wantedNumberOfRows	the number of rows desired

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getFirstXRecords(5));

getLargeNumberOfRecords() → Integer

Demonstrates how to loop over a SOQL query

Return

Type

Integer

Description

integer

Example

System.debug(SOQLRecipes.getLargeNumberOfRecords());

getParentRecordDetailsFromChildRecord() → List<Contact>

Demonstrates how to query fields from a parent object through the relationship field

Return

Type

List<Contact>

Description

List<Contact>

Example

System.debug(SOQLRecipes.getParentRecordDetailsFromChildRecord());

getRecords() → List<Account>

Demonstrates the proper way to query accounts with SOQL keeping FLS and CRUD in account.

Return

Type

List<Account>

Description

list<Account>

Example

List<Account> results = SOQLRecipes.querySingleObject();
System.debug(results);

getRecordsByFieldValue() → List<Account>

Demonstrates how to use a WHERE clause in a SOQL query

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getRecordsByFieldValue());

getRecordsByMultipleFieldValues() → List<Account>

Demonstrates how to use a complex WHERE clause in a SOQL query

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getRecordsByMultipleFieldValues());

getRecordsWithRelatedRecords() → List<Account>

Demonstrates how to query an object, as well as it's related child objects

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getRecordsWithRelatedRecords());

getSecond10AccountRecords() → List<Account>

Demonstrates how to get a limited number of results with a given offset; Ie: get the second set of 10 records.

Return

Type

List<Account>

Description

List<Account>

Example

System.debug('SOQLRecipes.getSecond10AccountRecords()');

getSpecificNumberOfRecords() → List<Account>

Demonstrates how to use the LIMIT clause in a SOQL statement

Return

Type

List<Account>

Description

List<Account>

Example

System.debug(SOQLRecipes.getSpecificNumberOfRecords());

getSumOfOpportunityRecords(Id accountId) → Double

demonstrates how to use aggregate methods, like Sum() or Count() in a SOQL query. This example generates the sum of opportunities associated with a specified Account

Parameters

Param	Description
accountId	an AccountId

Return

Type

Double

Description

Double

Example

Id accountId = [SELECT id FROM Account LIMIT 1].Id;
System.debug(SOQLRecipes.getSumOfOpportunityRecords(accountId));

---