How to create and query Salesforce Custom Address Field?
To create custom address fields in Salesforce, use the following steps. 1. Go to User Interface in Salesforce Setup. 2. Enable "Use custom address fields". Create a Custom Address Field. ....
Tag: Salesforce SOQL
How to get Apex Class Access for a profile using Apex in Salesforce?
Apex Classes assignment to a Profile are stored in SetupEntityAccess entity/object. So, by filtering ParentId with the Profile's Permission Set Id and SetupEntityType = 'ApexClass', we can fetch the Apex ....
Salesforce Legacy API Versions Retirement
To check the users and metadata components using the older legacy API versions check the following. Note: Update the versions as per the current versions that are getting retired. Using ....
Insufficient Privileges when viewing Salesforce EmailMessage Record
When viewing the EmailMessage records, the following Exception is thrown when the EmailMessage Status is 5 i.e draft. Insufficient PrivilegesYou do not have the level of access necessary to perform ....
Too many SOQL queries: 101 Salesforce Exception
System.LimitException: Too many SOQL queries: 101 Salesforce Exception is thrown when more than 100 SOQL queries are executed in a single synchronous transaction. For Asynchronous, the limit is 200. This ....
How to query Salesforce Custom Label Translations?
Custom Label Translations are stored in ExternalStringLocalization Entity. So, we can query using Tooling API. Custom Label Translations Sample SOQL: SELECT Id, ExternalStringId, ExternalString.MasterLabel, ExternalString.Value, Value, Language FROM ExternalStringLocalization WHERE ....
Check Salesforce Reports and Dashboards Subscriptions for an User
Option 1 - API: Report Subscription: https://{Your Domain URL}/services/data/v56.0/analytics/notifications?source=lightningReportSubscribe&ownerId=0053t00000AG695AAD Dashboard Subscription: https://{Your Domain URL}/services/data/v56.0/analytics/notifications?source=lightningDashboardSubscribe&ownerId=0053t00000AG695AAD Option 2 - SOQL: SELECT Id, CronJobDetailId, State FROM CronTrigger WHERE CronJobDetail.JobType = 'A' AND OwnerId ....
How to find time delay in Case creation from Salesforce Email-To-Case?
Time difference between Case Creation Date and Email Message MessageDate can be used to find time delay in Case creation from Salesforce Email-To-Case. Sample Code: for ( EmailMessage objEM : ....
Salesforce SOQL to find whether Lead was assigned via Assignment Rule
When a Lead record was assigned via Assignment Rule, in the Lead History entity, we should see an entry with ownerAssignment as the value in the Field column. Make sure ....
Edit and Delete Actions missing on Milestones from Salesforce Entitlement Process
If the version of the entitlement process is currently in use, then you can add new milestones. But, you can’t edit or delete the existing ones. If the versions of ....