Uncategorized

Query to find Permission sets assigned to Users

DescriptionBelow is the SOQL query we can create using Workbench to capture the Permission Sets associated with a given User or Profile via the Permission Set Assignment object ResolutionQuery: SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE Assignee.Name = ‘JOHN SMITH’ Or retrieve all users associated with a specific PermissionSet like: SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE PermissionSet.Name = ‘Custom […]

Salesforce

Salesforce Apex System.TypeException – Cannot have more than 10 chunks in single operation. Please rearrange the data to reduce chunking.

Solution: Please rearrange the data to reduce chunking. When I am trying to insert parent and child in same transaction while preparing the list of records to be inserted in a loop, I am getting this error as System.TypeException “Cannot have more than 10 chunks in a single operation. Please rearrange the data to reduce […]