Field History Tracking SOQL for Parent(Lookup or Master Detail) field in Salesforce
Sample SOQL:SELECT Id, OldValue, NewValue, Field FROM ContactHistory WHERE Field = 'Account' AND ContactId = '0035f000002a3PlAAI' Output:
Tag: Salesforce SOQL
Polymorphic Field in SOQL Queries in Salesforce
instanceof can be used to find the object type in Salesforce Apex. TYPEOF can be used to find the object type in Salesforce SOQL. For Task Object with What field: ....
How to find/query/SQOL all the Chatter Posts for a specific user in Salesforce?
To find/query/SQOL all the Chatter Posts for a specific user in Salesforce, run a SOQL FeedItem object/entity where InsertedById is filtered by the id of the user. SOQL: SELECT Id, ....
“Your org has too many waiting flow interviews” Exception in Salesforce
Exception:Your org has too many waiting flow interviews, including processes that are waiting to execute groups of scheduled actions. Wait for some interviews to complete, or delete unneeded interviews. https://help.salesforce.com/s/articleView?id=sf.process_limits_scheduled_processing.htm&type=5 ....
How to Query Salesforce Einstein Bot Event Logs?
1. Get the session id. 2. Use Data Loader. Sample SOQL: SELECT ConversationDefinitionId, CreatedById, CreatedDate, DialogDefinitionId, EventDateTime, EventLabel, EventTarget, EventTargetType, EventTimestamp, EventUuid, Id, IsDeleted, LastModifiedById, LastModifiedDate, LogLevel, LogType, ParentId, PreviousEventLogId, ....
Find users part of Permission Set License in Salesforce
Syntax:SELECT Id, UserName FROM User WHERE Id IN ( SELECT AssigneeId FROM PermissionSetLicenseAssign WHERE PermissionSetLicense.MasterLabel = '<Name of the Permission Set License' ) You can get the Name of the Permission ....
Files attached to Messages in Salesforce Messaging
Files are stored in ContentDocument entity. Use this soql to find the ContentDocumentId. SELECT ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId = '<MessagingSessionId>' Example: 1. Run the below SOQL.SELECT ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId ....
How to query all the list views for an object in Salesforce?
Salesforce List Views are stored in ListView object/entity. So, we have to use ListView object/entity to query all the list views for an object in Salesforce. Sample SOQL: SELECT Id, ....
How to query all the Visualforce Pages the profile have access to in Salesforce?
1. Run the below SOQL to get the PermissionSet Id. SELECT Id, Profile.Name FROM PermissionSet WHERE Profile.Name = 'System Administrator' 2. Use the PermissionSet Id from the step 1 and ....
How to query all the Apex Classes the profile have access to in Salesforce?
1. Run the below SOQL to get the PermissionSet Id. SELECT Id, Profile.Name FROM PermissionSet WHERE Profile.Name = 'System Administrator' 2. Use the PermissionSet Id from the step 1 and ....