How to execute Salesforce SOQL in VS Code?
8K views · Jul 5, 2022 infallibletechie.com
SOQL Builder in VS Code can be usedH to execute Salesforce SOQLs.
Find users who logged in using Auth Providers in Salesforce
4K views · Sep 22, 2022 infallibletechie.com
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/09/how-to-find-users-who-logged-in-using-auth-providers-in-salesforce.html
Find which agents missed the Salesforce Voice Calls
6K views · Oct 16, 2022 infallibletechie.com
Blog Post: https://www.infallibletechie.com/2022/10/how-to-find-which-agents-missed-the-salesforce-voice-calls.html
Query CombinedAttachment in Salesforce
6K views · Oct 20, 2022 infallibletechie.com
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
4K views · Oct 28, 2022 infallibletechie.com
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
10K views · Nov 7, 2022 infallibletechie.com
Blog Post: https://www.infallibletechie.com/2022/08/lastlogindate-in-salesforce.html
No such column BusinessHours on entity Case Exception in Sal...
983 views · Nov 18, 2022 infallibletechie.com
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 Salesforc...
620 views · Jan 11, 2023 infallibletechie.com
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
11K views · Feb 1, 2023 infallibletechie.com
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
6K views · Mar 8, 2023 infallibletechie.com
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 InvokeSalesforceRestApi...
59K views · Apr 28, 2023 infallibletechie.com
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-service-cloud-voice.html
Update AccountId on Salesforce User record
8K views · Jun 5, 2023 infallibletechie.com
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. Blog Post: https://www.infallibletechie.com/2023/05/update-accountid-on-salesforce-user-record.html
Track undelivered messages in Salesforce Digital Engagement ...
7K views · Jun 7, 2023 infallibletechie.com
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.infallibletechie.com/2021/12/how-to-track-failedundelivered-messages.html
Query Salesforce Presence Configurations
609 views · Jul 15, 2023 infallibletechie.com
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
589 views · Jul 17, 2023 infallibletechie.com
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
5K views · Jul 19, 2023 infallibletechie.com
Blog Post: https://www.infallibletechie.com/2023/02/salesforce-legacy-api-versions-retirement.html
Permission Set License Assignments using Salesforce SOQL
6K views · Aug 1, 2023 infallibletechie.com
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
2K views · Aug 9, 2023 infallibletechie.com
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
12K views · Aug 13, 2023 infallibletechie.com
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
1K views · Aug 19, 2023 infallibletechie.com
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-presence-statuses.html
Find the Files that are downloaded by an user in Salesforce
14K views · Aug 27, 2023 infallibletechie.com
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 that are downloaded by an user. Blog Post: https://www.infallibletechie.com/2023/08/how-to-find-the-files-that-are-downloaded-by-an-user-in-salesforce.html
Query setup objects in Salesforce Developer console
20K views · Sep 3, 2023 infallibletechie.com
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-to-query-setup-objects-in-developer.html
Create and query Salesforce Custom Address Field
39K views · Sep 25, 2023 infallibletechie.com
"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__s, __Longitude__s, __GeocodeAccuracy__s prefixed with the Field Name. Blog Post: https://www.infallibletechie.com/2023/03/how-to-create-and-query-salesforce-custom-address-field.html
Find if an user have a specific Salesforce Permission
1K views · Oct 6, 2023 infallibletechie.com
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 Salesforce Permission. Blog Post: https://www.infallibletechie.com/2023/08/how-to-find-if-an-user-have-a-specific-salesforce-permission.html
SOQL to find code coverage in Salesforce
27K views · Oct 21, 2023 infallibletechie.com
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: ApexCodeCoverage stores the lines that are covered and uncovered by each individual test method. Blog Post: https://www.infallibletechie.com/2014/06/soql-to-find-code-coverage-in-salesforce.html
Find Users status changes in Salesforce Omni Channel
626 views · Oct 26, 2023 infallibletechie.com
SOQL on UserServicePresence can be used to track user status changes in Salesforce Omni-channel. Blog Post: https://www.infallibletechie.com/2022/03/how-to-find-users-status-changes-in.html
Query Salesforce Chatter Groups
724 views · Nov 26, 2023 infallibletechie.com
Salesforce Chatter Groups are stored in CollaborationGroup object or entity. Blog Post: https://www.infallibletechie.com/2023/09/query-salesforce-chatter-groups.html
Query Salesforce Omni Channel Supervisor Configurations
857 views · Jan 22, 2024 infallibletechie.com
OmniSupervisorConfig is the object/entity where Salesforce Omni-Channel Supervisor Configurations are stored. So, we have to query the OmniSupervisorConfig object/entity to fetch the Salesforce Omni-Channel Supervisor Configurations. Blog Post: https://www.infallibletechie.com/2024/01/how-to-query-salesforce-omni-channel-supervisor-configurations.html
NOT LIKE Operator in Salesforce SOQL
2K views · Jan 25, 2024 infallibletechie.com
We can use both NOT and LIKE operators in Salesforce SOQLs. Blog Post: https://www.infallibletechie.com/2018/11/not-like-operator-in-salesforce-soql.html
Query Field History Tracking records in Salesforce
2K views · Feb 4, 2024 infallibletechie.com
If field history tracking is enabled for an object, the changes are stored in history table for that particular object. Blog Post: https://www.infallibletechie.com/2014/10/how-to-query-field-history-tracking.html
SOQL to find whether users have logged in to the Sandbox
3K views · Feb 17, 2024 infallibletechie.com
SOQL on the Login History object/entity can be used to find whether users have logged in to the Sandbox. Blog Post: https://www.infallibletechie.com/2018/12/soql-to-find-whether-users-have-logged.html
Salesforce Omni Channel Supervisor Configurations Users Assi...
870 views · Feb 16, 2024 infallibletechie.com
OmniSupervisorConfigUser is the object/entity where Salesforce Omni-Channel Supervisor Configurations Users assignments are stored. So, we have to query the OmniSupervisorConfigUser object/entity to fetch the Salesforce Omni-Channel Supervisor Configurations Users assignment. Blog Post: https://www.infallibletechie.com/2024/02/how-to-query-salesforce-omni-channel-supervisor-configurations-assignment.html
Dynamically Pass Bind Variables to a Salesforce SOQL Query S...
2K views · Feb 20, 2024 infallibletechie.com
Database.queryWithBinds() in Salesforce Apex allows us to dynamically pass bind variables values to a Salesforce SOQL Query string. Map of String, Object datatype reduces the number of parameters declaration in the method. Blog Post: https://www.infallibletechie.com/2023/12/dynamically-pass-bind-variables-to-a-salesforce-soql-query-string.html
Query DateTime field in Salesforce
21K views · Feb 18, 2024 infallibletechie.com
Salesforce stores the DateTime in GMT/UTC. Blog Post: https://www.infallibletechie.com/2019/03/how-to-query-datetime-field-in.html
Query Salesforce Einstein BOT Intent Detection
2K views · Feb 22, 2024 infallibletechie.com
SOQL query on the ConversationDefinitionEventLog object/entity can be used to query Salesforce Einstein BOT Intent Detection. Blog Post: https://www.infallibletechie.com/2023/11/query-salesforce-einstein-bot-intent-detection.html
Find Salesforce Users with Unverified Email Addresses
43K views · Mar 17, 2024 infallibletechie.com
We can use the TwoFactorMethodsInfo object/entity to query the users who haven't verified their email addresses yet in Salesforce. Blog Post: https://www.infallibletechie.com/2023/08/find-salesforce-users-with-unverified-email-addresses.html
Parent and Child records in Salesforce SOQL using REST API
1K views · Mar 22, 2024 infallibletechie.com
Sub-Query can be used to Parent and Child records in Salesforce SOQL using REST API. Blog Post: https://www.infallibletechie.com/2023/04/parent-child-records-in-salesforce-soql-using-rest-api.html
Retrieve Picklist Value Set or Global Picklists in Salesforc...
633 views · Apr 24, 2024 infallibletechie.com
GlobalValueSet can be used in the package.xml file to retrieve the Picklist Value Set/Global Picklists in Salesforce. Check the following package.xml for reference. Blog Post: https://www.infallibletechie.com/2021/03/sample-packagexml-to-retrieve-picklist.html
Find specific Permission enabled in Salesforce Profiles and ...
445 views · Apr 30, 2024 infallibletechie.com
We can run SOQLs on Profile and PermissionSet to find specific Permission enabled in Salesforce Profiles and Permission Sets. Blog Post: https://www.infallibletechie.com/2023/09/find-specific-permission-enabled-in-salesforce-profiles-and-permission-sets.html
Query Salesforce users using specific Login IP
239 views · Apr 28, 2024 infallibletechie.com
SourceIp from LoginHistory object/entity can be used to query Salesforce users using specific Login IP. Blog Post: https://www.infallibletechie.com/2024/02/how-to-query-salesforce-users-using-specific-login-ip.html
Query Compliance Categorization for a Salesforce Field
7K views · May 6, 2024 infallibletechie.com
Compliance Categorization(ComplianceGroup) is stored in FieldDefinition object/entity. We can query the FieldDefinition object/entity to query Compliance Categorization for a Salesforce Field. Blog Post: https://www.infallibletechie.com/2024/01/how-to-query-compliance-categorization-for-a-salesforce-field.html
Conversation Entries for Messaging Session in Salesforce Mes...
2K views · May 9, 2024 infallibletechie.com
To get Conversation Entries for Messaging Session in Salesforce Messaging Channels(SMS, WhatsApp, Facebook, etc..), we can query the ConversationEntry object/entity using the Messaging Session Id as the ConversationId. Blog Post: https://www.infallibletechie.com/2024/01/how-to-get-conversation-entries-for-messaging-session-in-salesforce-messaging-channels.html
Workaround for ContentDocumentLink requires a filter by a si...
312 views · May 16, 2024 infallibletechie.com
"Query All Files" Permission can be used when we hit the exception "Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator". Blog Post: https://www.infallibletechie.com/2024/03/workaround-for-contentdocumentlink-requires-a-filter-by-a-single-id-on-contentdocumentid-or-linkedentityid.html
Query Salesforce Knowledge Article Data Categories Assignmen...
2K views · May 21, 2024 infallibletechie.com
To find Salesforce Knowledge Article Data Categories Assignment, we have to query the knowledge__DataCategorySelection object/entity. Blog Post: https://www.infallibletechie.com/2024/04/query-salesforce-knowledge-article-data-categories-assignment.html
Query all Salesforce Standard Profiles
322 views · May 27, 2024 infallibletechie.com
In order to find or query all the Standard Profiles in Salesforce, we have to query the ProfileId from the PermissionSet object/entity where IsCustom is equal to false and IsOwnedByProfile is equal to true. Blog Post: https://www.infallibletechie.com/2024/03/query-all-salesforce-standard-profiles.html
Handle Salesforce SOQL Offset Limitation
164 views · Jun 13, 2024 infallibletechie.com
In Salesforce SOQL, we cannot set the Offset value more than 2000. In order to overcome the Offset limitation, we can avoid using it and order the records based on the Id using ORDER BY Clause in the SOQL and retrieve them by filtering in subsequent requests. Blog Post: https://www.infallibletechie.com/2024/06/handle-salesforce-soql-offset-limitation.html
Query Salesforce Custom Label Translations
720 views · Jul 7, 2024 infallibletechie.com
Custom Label Translations are stored in ExternalStringLocalization Entity. So, we can query using Tooling API. Blog Post: https://www.infallibletechie.com/2023/02/how-to-query-salesforce-custom-label-translations.html
Query Salesforce Connected App
289 views · Jul 10, 2024 infallibletechie.com
ConnectedApplication entity can be to query Salesforce Connected App. Use SOQL on ConnectedApplication entity to query Connected App details. Blog Post: https://www.infallibletechie.com/2023/05/how-to-query-salesforce-connected-app.html
Fetch records followed in Salesforce Chatter Stream
447 views · Jul 17, 2024 infallibletechie.com
ConntectApi can be used to get the records that are followed in Salesforce Chatter Streams. Blog Post: https://www.infallibletechie.com/2023/02/how-to-fetch-records-followed-in-salesforce-chatter-stream.html
Use of IN operator in SOQL in Salesforce
360 views · Jul 31, 2024 infallibletechie.com
IN operator in Salesforce SOQL is used to include multiple filter values. Blog Post: https://www.infallibletechie.com/2013/08/use-of-in-operator-in-soql-in-salesforce.html
Query Salesforce Permission Sets and Profiles with Password ...
100 views · Sep 10, 2024 infallibletechie.com
To find Salesforce Profiles and Permission Sets with Password Never Expires permission enabled, we have to check PermissionsPasswordNeverExpires on the Profile and PermissionSet object/entity. Blog Posts: https://www.infallibletechie.com/2024/04/query-salesforce-profiles-with-password-never-expires.html https://www.infallibletechie.com/2024/09/query-salesforce-permission-sets-with-password-never-expires.html
Query Salesforce Omni Channel Supervisor Configurations Prof...
890 views · Feb 26, 2025 infallibletechie.com
OmniSupervisorConfigProfile is the object/entity where Salesforce Omni-Channel Supervisor Configurations Profiles assignments are stored. So, we have to query the OmniSupervisorConfigProfile object/entity to fetch the Salesforce Omni-Channel Supervisor Configurations Profiles assignment. Blog Post: https://www.infallibletechie.com/2024/02/how-to-query-salesforce-omni-channel-supervisor-configurations-profiles-assignment.html
Chatter Posts for a specific user in Salesforce
276 views · Mar 27, 2025 infallibletechie.com
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. Blog Post: https://www.infallibletechie.com/2021/10/how-to-findquerysqol-all-chatter-posts.html
NOT IN Operation in Salesforce SOQL
101 views · Apr 3, 2025 infallibletechie.com
NOT() and IN() are two different methods in Salesforce SOQL Query. We don't have NOT IN() method in the Salesforce SOQL Query. Blog Post: https://www.infallibletechie.com/2023/11/not-in-operation-in-salesforce-soql.html