-
Notifications
You must be signed in to change notification settings - Fork 519
SOQLRecipes
Demonstrates how to make various types of SOQL calls including multi-object queries, and aggregate queries
Group Data Recipes
Demonstrates the proper way to query accounts with SOQL keeping FLS and CRUD in account.
| Type | Description |
|---|---|
| List | list |
List<Account> results = SOQLRecipes.querySingleObject();
System.debug(results);Demonstrates how to loop over a SOQL query
| Type | Description |
|---|---|
| Integer | integer |
System.debug(SOQLRecipes.getLargeNumberOfRecords());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.
| Type | Description |
|---|---|
| Integer | Integer |
Demonstrates how to use a WHERE clause in a SOQL query
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getRecordsByFieldValue());Demonstrates how to use a complex WHERE clause in a SOQL query
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getRecordsByMultipleFieldValues());Demonstrates how to use the LIMIT clause in a SOQL statement
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getSpecificNumberOfRecords());Demonstrates how to use a bound variable to define the LIMIT
| Param | Description |
|---|---|
wantedNumberOfRows |
the number of rows desired |
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getFirstXRecords(5));Demonstrates how to use a bound variable in a WHERE clause
| Param | Description |
|---|---|
state |
String representing a US State code (AK, KS, etc.) |
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getAccountRecordsInState('ks'));Demonstrates how to get a limited number of results with a given offset; Ie: get the second set of 10 records.
| Type | Description |
|---|---|
| List | List |
System.debug('SOQLRecipes.getSecond10AccountRecords()');Demonstrates how to query an object, as well as it's related child objects
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getRecordsWithRelatedRecords());Demonstrates how to query fields from a parent object through the relationship field
| Type | Description |
|---|---|
| List | List |
System.debug(SOQLRecipes.getParentRecordDetailsFromChildRecord());Demonstrates how to write a query that pulls information from two parent objects through a junction object
| Type | Description |
|---|---|
| List<Junction__c> | List<Junction__c> |
System.debug(SOQLRecipes.getDetailsFromBothParentRecords());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
| Param | Description |
|---|---|
accountId |
an AccountId |
| Type | Description |
|---|---|
| Double | Double |
Id accountId = [SELECT id FROM Account LIMIT 1].Id;
System.debug(SOQLRecipes.getSumOfOpportunityRecords(accountId));