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 ....
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 ....
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 ....