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 ....
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
"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 ....
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 ....
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 ....
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 ] ) ....
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 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 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 ....
CreatedDate: Created Date Time of the record. CreatedById: Id of the user who created the record. Sample SOQL: SELECT Id, CreatedDate, CreatedById, CreatedBy.Name FROM Account LIMIT 5