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 ....
Tag: Salesforce SOQL
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 ....
How to fetch report name and format using SOQL in Salesforce?
Sample SOQL: SELECT Name, Format FROM Report here Name - Name of the report. Format - Format of the report(Tabular, Summary, Matrix, MultiBlock(Joined report)). For additional queries and fields, check https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_report.htm
How to fetch records form recycle bin in Salesforce?
"ALL ROWS" keyword is used to fetch records form recycle bin in Salesforce. Sample SOQL: SELECT Id, AccountId FROM Contact WHERE IsDeleted = true ALL ROWS Execute the below code in ....
How to get all the trigger names from a Salesforce Organization?
All the Salesforce triggers will be stored in ApexTrigger Entity. So, we can execute a SOQL fetch all the trigger names from a Salesforce Organization. Sample SOQL: SELECT Id, Name, TableEnumOrId ....
How to change the owner to the default owner when transferring records from one org to another using SALESFORCE TO SALESFORCE?
ConnectionReceivedId is the ID of the PartnerNetworkConnection that shared record with your organization. So, write a trigger on before insert that owner should be changed to default owner, when ConnectionReceivedId is ....
How to get Product Name from Opportunity Line item in SOQL?
Sample Query: SELECT PricebookEntry.Product2.Name FROM OpportunityLineItem (Or) SELECT PricebookEntry.Name FROM OpportunityLineItem LIMIT 10 Sample Code: for ( OpportunityLineItem OLI : [ SELECT PricebookEntry.Product2.Name, PricebookEntry.Name FROM OpportunityLineItem LIMIT 10 ] ) ....
Difference between SOQL and SOSL
SOQL SOSL SOQL is used if we know in which object the data is present. SOSL is used if we don't know in which object the data is present. In ....
FOR REFERENCE in SOQL
FOR REFERENCE is used to notify Salesforce when a record is referenced. The LastReferencedDate field is updated for any retrieved records. Sample Query: SELECT City__c, State__c, LastReferencedDate FROM Employee__c FOR ....
Alias Notation in Salesforce SOQL
Alias Notation is allowed in Salesforce SOQL. In the following sample SOQL, I have used Con as alias for Contact object and Acct for the Account object. Sample SOQL: SELECT ....