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 != ....
Sample SOQL:SELECT Id, Name, ( SELECT Id, Subject, Status FROM ActivityHistories ) FROM Account WHERE Id = '0018c000026ZmPmAAK' Output:
Sample Contact Record: SOQL:SELECT Id, AccountId, Account.Name FROM AccountContactRelation WHERE ContactId IN (SELECT Id FROM Contact WHERE Email = '[email protected]' ) Output:
Sample SOQL:SELECT Id, Name FROM User WHERE UserPermissionsSupportUser = true Output:
Sample SOQL: SELECT COUNT( LiveChatTranscriptId ) FROM LiveChatTranscriptEvent WHERE Type = 'TransferredToButton' AND LiveChatTranscript.Status = 'Completed' AND CreatedDate = LAST_N_DAYS:7 Output: