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 ....
Tag: Salesforce SOQL
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 ....
Error: Invalid field ‘Opportunity.Contract’ specified
Exception: Error: Invalid field 'Opportunity.Contract' specified Resolution: Use ContractId instead of Contract. Sample Query: SELECT Name, ContractId FROM Opportunity LIMIT 2
How to get converted Contact Id after Lead conversion in Salesforce?
When the Lead is converted to Account, Contact and Opportunity in Salesforce, ConvertedContactId on the Lead Object will contain the Contact Id after the Lead Conversion. Sample Query: SELECT Name, ConvertedContactId FROM ....
How to check the login histories of all the users in Salesforce?
To check the login histories of all the users in Salesforce, go to Setup --> Administer --> Manage Users --> Login History. SOQL: SELECT Id, LoginTime, UserId FROM LoginHistory WHERE ....
How to query Field History Tracking records in Salesforce?
If field history tracking is enabled for an object, the changes are stored in history table for that particular object. The API name of these tables follows a simple convention ....