salesforce – SOQL Query on FieldPermissions
I want to list out Read and Write permissions for a few fields on an object from a profile.
I have a profile named CAPI and under the profile I want to find out all the field permissions from Account object. I’ve constructed this query for it
SELECT SObjectType, Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE SObjectType="Account" AND Field IN('Name','ShippingStreet','ShippingCity') AND Parent.Profile.Name="capi"
But no data gets exported when I execute it. What am I doing wrong? Any suggestions would be appreciated.
Read more here: Source link