Hello awesome admins,
I am trying to use data loader to identify profiles (not permission sets) that have view or edit access to a field. This is my data loader query so far:
SELECT Field, Id, ParentId, PermissionsEdit, PermissionsRead
FROM FieldPermissions
WHERE
SobjectType = 'Opportunity'
AND Field = 'Opportunity.Special__c'
AND (PermissionsEdit = True
OR PermissionsRead = true)
I would like the export to include the Profile Name. Also, my goal is to use the export to then update some of the Profiles so that PermissionsEdit and PermissionsRead = False.
1. How do I include Profile Name in my query?
2. When I do the Update, which object should I be updating... is it the FieldPermissions object again?
Thank you!
Select SobjectType, Field,ParentId , parent.Label, parent.profile.name From FieldPermissions where PermissionsEdit = true and PermissionsRead = true
