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 ....
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
Generally in SOQL, null values are sorted first. In order to sort null values at last make use of NULLS LAST keyword. Sample SOQL: SELECT Id, Name, Industry FROM Account ....
SOQL: SELECT UserRole.Name, Profile.Name FROM User Output: