How to execute Salesforce SOQL in VS Code?
SOQL Builder in VS Code can be usedH to execute Salesforce SOQLs.
Find users who logged in using Auth Providers in Salesforce
We can query LoginHistory entity using AuthenticationServiceId to find the users who logged in using Social Logins. AuthenticationServiceId refers to Auth. Provider Id which is used in the Social Login. Blog Post: https://www.infallibletechie.com/2022/
Find which agents missed the Salesforce Voice Calls
Blog Post: https://www.infallibletechie.com/2022/10/how-to-find-which-agents-missed-the-salesforce-voice-calls.html
Query CombinedAttachment in Salesforce
We cannot query CombinedAttachment object/entity as Query() is not supported. So, we can use Sub-Query to fetch CombinedAttachment records. Blog Post: https://www.infallibletechie.com/2022/10/how-query-combinedattachment-in-salesforce.html
Monitor Salesforce Change Data Capture Events usage
Blog Post: https://www.infallibletechie.com/2022/09/how-to-monitor-salesforce-change-data-capture-events-daily-or-24-hour-or-hourly-period-usage.html
Last Login Date Time in Salesforce
Blog Post: https://www.infallibletechie.com/2022/08/lastlogindate-in-salesforce.html
No such column BusinessHours on entity Case Exception in Salesforce
Blog Post: https://www.infallibletechie.com/2022/09/no-such-column-businesshours-on-entity-case-exception-in-salesforce.html
Edit and Delete Actions missing on Milestones from Salesforce Entitlement Process
Blog Post: https://www.infallibletechie.com/2022/11/edit-and-delete-actions-missing-on-milestones-from-salesforce-entitlement-process.html
Query Salesforce Picklist Field values using SOQL
Blog Post: https://www.infallibletechie.com/2022/10/how-to-query-salesforce-picklist-field-values-using-soql.html
Query Field Permissions for a Profile in Salesforce
Use FieldPermissions Entity to Query Field Permissions for a Profile in Salesforce. Blog Post: https://www.infallibletechie.com/2018/09/how-to-query-field-permissions-for.html
Query Salesforce Custom Object using InvokeSalesforceRestApiFunction
In InvokeSalesforceRestApiFunction Lambda, queryRecord method can be used to fetch or query custom object records in Salesforce. Blog Post: https://www.infallibletechie.com/2023/01/query-custom-object-using-invokesalesforcerestapifunction-for-salesforce-
Update AccountId on Salesforce User record
AccountId field on the User object is read only. It is derived from Contact's AccountId field. We cannot update AccountId on the User object. The Contact record's AccountId field should be updated so that it will also gets reflected on the User object. B
Track undelivered messages in Salesforce Digital Engagement Messaging
In ConversationEntry entity, MessageStatusCode will be populated if the messages are undelivered. So, query the ConversationEntry entity with MessageStatusCode to track failed or undelivered Messages in Salesforce Messaging. Blog Post: https://www.infall
Query Salesforce Presence Configurations
Salesforce Presence Configurations are stored in PresenceUserConfig entity. Blog Post: https://www.infallibletechie.com/2023/07/how-to-query-salesforce-presence-configurations.html
SOQL to find whether Lead was assigned via Assignment Rule
Blog Post: https://www.infallibletechie.com/2022/11/salesforce-soql-to-find-whether-lead-was-assigned-via-assignment-rule.html
Salesforce Legacy API Versions Retirement
Blog Post: https://www.infallibletechie.com/2023/02/salesforce-legacy-api-versions-retirement.html
Permission Set License Assignments using Salesforce SOQL
Salesforce SOQL query can be used to find users who are assigned as part of Permission Set License Assignments. Blog Post: https://www.infallibletechie.com/2023/06/how-to-query-permission-set-license-assignments-using-salesforce-soql.html
Query Object Permissions for a Profile in Salesforce
Object Permissions for a Profile in Salesforce are stored in the ObjectPermissions Entity. Blog Post: https://www.infallibletechie.com/2018/09/how-to-query-object-permissions-for.html
Query Salesforce Process Builder
Use Tooling API, we can query Process Builders in Salesforce. Blog Post: https://www.infallibletechie.com/2021/09/querysoql-process-builder-salesforce.html
Query Salesforce Presence Statuses
Salesforce Presence Statuses are stored in ServicePresenceStatus object/entity. So, we can query ServicePresenceStatus object/entity to get the Salesforce Presence Statuses. Blog Post: https://www.infallibletechie.com/2023/07/how-to-query-salesforce-pres
Find the Files that are downloaded by an user in Salesforce
Whenever Files or Documents are download, there will be an entry in ContentVersionHistory entity or object in Salesforce. So, we can query the ContentVersionHistory entity/object with Field value as contentVersionDownloaded to find the files or documents
Query setup objects in Salesforce Developer console
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. Blog Post: https://www.infallibletechie.com/2014/10/how-t
Create and query Salesforce Custom Address Field
"Use custom address fields" in Salesforce Setup User Interface section should be enabled to create Custom Address Field. To query the Custom Address Field values, use __StateCode__s, __CountryCode__s, __Street__s, __PostalCode__s, __City__s, __Latitude__
Find if an user have a specific Salesforce Permission
Salesforce Permissions assigned to an user are stored in Permission Sets and Profiles. Permission Set assigned to an user are stored in PermissionSetAssignment object/entity. So, by querying these two objects, we can figure out if an user have a specific
SOQL to find code coverage in Salesforce
Code coverage is stored in two Lightning Platform Tooling API objects: 1. ApexCodeCoverageAggregate: ApexCodeCoverageAggregate stores the sum of covered lines for a class after checking all test methods that test it. 2. ApexCodeCoverage: ApexCodeCove