Hello,
I am trying to apply security predicate for a dataset and I want the data to be restricted only to logged in user's Country. The user who logs into EA should see only his Country related data in the dataset.
I have achieved that by using the following predicate: 'Region.Name' == "$User.Country"
When I apply the above predicate, am only seeing data related to my region. Now, is there anyway to exclude system admin profile from this security predicate as I need to see all the rows as a system admin.
This might be a basic question but I am learning..so thank you guys in advance :)
You can create a column to your dataset with the fixed admin role and add this condition to your predicate.
e.g. new column 'View profile' containing "Salesforce Admin" and then predicate '
Region.Name' == "$User.Country" || 'View profile' == $User.Profile