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 = 'test@test.com' ) 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:
"like operator only valid on string field" exception occurs if the LIKE operator in SOQL is used again non-string fields. In SOQL, the LIKE operator is supported for string fields only. ....