Use FieldPermissions Entity to Query Field Permissions for a Profile in Salesforce. Sample SOQL: SELECT sObjectType, Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE ParentId IN ( SELECT Id FROM PermissionSet WHERE ....
Object Permissions for a Profile in Salesforce are stored in the ObjectPermissions Entity. Sample SOQL: SELECT sObjectType, PermissionsCreate, PermissionsRead, PermissionsEdit, PermissionsDelete, PermissionsModifyAllRecords, PermissionsViewAllRecords FROM ObjectPermissions WHERE ParentId IN ( SELECT ....
FieldPermissions represents the enabled field permissions for the parent PermissionSet. This object is available in API version 24.0 and later. FieldPermissions records are only supported in PermissionSet, not in Profile. ....
Using aggregate SOQL, we can find the number of child records for each parent record in Salesforce.Check the following sample SOQL. Since AccountId is grouped by, it will find the ....
COUNT() in SOQL can be used to get the records count of the SOQL query execution value into a variable in Salesforce. Sample Code: public static Integer findAcctCount() { return ....
Starting from the specified target date, returns the next date when business hours are open. If the specified target date falls within business hours, this target date is returned. Sample ....
Two-column custom indexes are a specialized feature of the Salesforce platform. They are useful for list views and situations where you want to use one field to select records to ....
Salesforce supports custom indexes to speed up queries, and you can create custom indexes by contacting Salesforce Customer Support by creating a Case. Note: The custom indexes that Salesforce Customer ....
System.QueryException: Aggregate query has too many rows for direct assignment, use FOR loop Salesforce Exception is thrown when the sub-query returns too many rows. In order to avoid System.QueryException: Aggregate ....
LIKE operator in SOQL can be used against set of strings. Use : to check against Set < String > variable. Check the following code for reference. Sample Code: Set ....