I am trying to implement a security predict in a dataset that allows Opportunity Owners and the hierarchy above them to view the data. I followed this documentation, but when I test everyone is able to view all the data.
Add Row-Level Security with a Security Predicate (salesforce.com)
I created a separate recipe that joins User and UserRole to get a table with the flattened ParentRoleId related to each User. I then joined the UserId from that to the Opportunity Owner ID in the recipe with the dataset I'm working on.
This is what I've been trying based on the documentation. Does anyone know what I could be doing wrong?
'OppOwner.Id' == "$User.Id" || 'OppOwner.User_roles.Roles.Id_flatten_multiField' == "$User.UserRoleId"
Hi @Andrew Cook
,
The expression 'flatten_multiField' IN ($User.UserRoleId) doesn't work. It's not possible configure it into dataset security predicate field.
