SOQL can be used find the last data entry date on Standard and Custom object in Salesforce. Sample SOQL: SELECT Id, CreatedDate FROM Account WHERE CreatedDate = LAST_N_DAYS:5 ORDER BY ....
Chat Session records are stored in LiveAgentSession entity. Following Sample code can be used to delete the Chat Session records permanently(hard delete). Sample Code: List < LiveAgentSession > listLiveAgentSessions = ....
SOQL on UserRecordAccess entity can be used to find user's record access in Salesforce. SOQL Syntax: SELECT RecordId, HasReadAccess, HasTransferAccess, MaxAccessLevel, HasAllAccess, HasDeleteAccess FROM UserRecordAccess WHERE UserId = '<User Id>' ....
A simple SOQL on NetworkMember object can be used to find Email Preferences of the Salesforce Experience Cloud Site Users Sample SOQL: SELECT Id, Network.Name, Member.Name, DigestFrequency, PreferencesDisableAllFeedsEmail, PreferencesDisableBestAnswerEmail, PreferencesDisableBookmarkEmail, ....
SOQLs: SOQL to find users part of the Permission Set:SELECT Assignee.Name FROM PermissionSetAssignment WHERE PermissionSetId = '0PS8c000003LCCL' SOQL to find users part of the Permission Group :SELECT Assignee.Name FROM PermissionSetAssignment WHERE PermissionSetGroupId ....
SOQL on UserServicePresence can be used to track user status changes in Salesforce Omni-channel. Sample SOQL: SELECT Id, Name, User.Name, ServicePresenceStatus.DeveloperName, StatusStartDate, StatusEndDate FROM UserServicePresence WHERE StatusStartDate = LAST_N_DAYS:15 ORDER BY ....
System.QueryException: unexpected token: '<EOF>' exception in Salesforce occurs due to Malformed Query String. If you are dynamically building the query, use System.debug() to print the query. Generated Debug log to ....
To find Report references in a Dashboard, use the following SOQL. Sample SOQL: SELECT Dashboard.Title FROM DashboardComponent WHERE CustomReportId = '00O8c000007uh5UEAQ' Output:
"PermissionsApiEnabled" is used to grant API Enabled Permission to the user via Profile or Permission Set. Following SOQLs can be used to find users with API Enabled Permissions(API Only Users) ....
FieldDefinition can be used to Query/SOQL Field Dependency for an Object in Salesforce. Sample Field Dependency: SOQL: SELECT Label, QualifiedApiName, DataType, ControllingFieldDefinition.DeveloperName FROM FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Employee__c' AND ControllingFieldDefinitionId != ....