function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ankit SatnalikaAnkit Satnalika 

Query result based on Profile

My requirement is to get all the fields in an object having read access for a particular profile.
Can anybody help me with the Query.
 
Sudhir gonuguntlaSudhir gonuguntla
Find Query below 
  
SELECT Id, Field, SObjectType, PermissionsRead FROM FieldPermissions WHERE PermissionsRead = True AND parentId IN 
(SELECT id FROM permissionset WHERE PermissionSet.Profile.Name = 'System Administrator')

 
Sudhir gonuguntlaSudhir gonuguntla
If you want to get it from one object , then try this below  
SELECT Id, Field, SObjectType, PermissionsRead FROM FieldPermissions WHERE PermissionsRead = True AND SObjectType = 'Opportunity' AND parentId IN ( SELECT id FROM permissionset WHERE PermissionSet.Profile.Name = 'System Administrator')

 
SarvaniSarvani
Hello Ankit,

Try the query below 
SELECT Id, Field, SObjectType, PermissionsRead FROM FieldPermissions WHERE parentId IN ( SELECT id FROM permissionset  WHERE PermissionSet.Profile.Name = 'System Administrator') AND Permissionsread=true AND SobjectType='Account'
Chane your SobjectType, Profile Name as per your requirement.

Hope this helps ! Mark as solved if it did.

Thanks,
Sarvani