Tag: Salesforce SOQL

A query locator represents a server-side cursor for a query. Typically a query locator is returned when not all the records requested in a query fit into the returned data ....

For the number n provided, it starts with the time 00:00:00 of the current day and continues for the past n days. It includes today also. Sample SOQL: SELECT Id ....

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 ....

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 ....