Indexing in Salesforce
Salesforce supports custom indexes to speed up queries, and you can create custom indexes by contacting Salesforce Customer Support by creating a Case. Note: The custom indexes that Salesforce Customer ....
Tag: Salesforce SOQL
System.QueryException: Aggregate query has too many rows for direct assignment, use FOR loop
System.QueryException: Aggregate query has too many rows for direct assignment, use FOR loop Salesforce Exception is thrown when the sub-query returns too many rows. In order to avoid System.QueryException: Aggregate ....
LIKE operator in SOQL against set of strings
LIKE operator in SOQL can be used against set of strings. Use : to check against Set < String > variable. Check the following code for reference. Sample Code: Set ....
convertCurrency() in Salesforce
Use convertCurrency() in a SOSL query to convert currency fields to the user’s currency. This action requires that the organization is multi-currency enabled. Syntax: convertCurrency(Amount) Example: FIND {test} RETURNING Opportunity(Name, ....
Alias in Salesforce User Creation
An alias is a short name to identify the user on list pages, reports, or other places where their entire name doesn't fit. By default, the alias is the first ....
SOQL Injection
SOQL Injection can occur in Apex code whenever your application relies on end user input to construct a dynamic SOQL statement and you do not handle the input properly. To ....
Compound Fields in Salesforce
Compound fields in Salesforce group together multiple elements of primitive data types, such as numbers or strings, to represent complex data types, such as a location or an address. Compound ....
CronTrigger object in Salesforce
All the scheduled jobs are stored in CronTrigger object in Salesforce. To view the Scheduled Jobs in Salesforce, check the below steps: 1. Go to Setup --> Jobs --> Scheduled ....
Query Plan in Salesforce
The new Query Plan tool in the Developer Console can help speed up SOQL queries done over large volumes. Use the Query Plan tool to optimize and speed up queries ....
SOQL to get Account ids where Contact count is greater than 2
Sample Query: SELECT AccountId FROM Contact GROUP BY AccountId HAVING COUNT(AccountId) > 2 This SOQL query is used to get Account Ids where related Contacts count is greater than 2 ....