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 ....
Tag: Salesforce SOQL
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 ....
How to query setup objects inSalesforce Developer console?
Salesforce Tooling API’s SOQL capabilities for many metadata types allow us to retrieve metadata using queries. Enable "Use Tooling API" to query setup objects in Developer console in Salesforce. Please check ....