Salesforce Platform Developer I Certification Guide

Selecting records with dynamic parameters

Custom build applications, or trigger functionality, does not have some of the queries we saw previously. These queries are based on the user's input or on dynamic parameters. In that case, you can create your queries in two ways:

• Dynamic queries: We create a string with the full query and execute the query with the Database.query(String) statement:

String sAccountName = 'Burlington%';String sQuery = 'SELECT Id, Name FROM Account WHERE Name Like \'' + sAccountName + '\'';List<Account> lstAccounts = (List<Account>) Database.query(sQuery); // we cast the result of the query (a list with SObjects) to a list with accounts

• A dynamic parameter in your query: This is the recommended way to perform SOQL ...