Uncategorized

Understand & Fixing Salesforce System.LimitException: Too many query rows: 50001

Introduction to Salesforce Governor Limits What are Governor Limits? Salesforce is a multi-tenant environment, which means your code runs on a shared infrastructure. To ensure fair use of resources, Salesforce enforces limits known as governor limits. These rules help prevent any one user or org from monopolizing server resources. Why Do They Exist in Salesforce? […]

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 […]