Each row of my data can identify a type of transaction up to 6 different ways.
Example shortened to 3 transaction type columns:
cheeseburger | 1 | 5.25 | food | | |
t-shirt | 1 | 9.99 | retail | | |
combo pkg | 1 | 99 | giftcard | retail | food |
I want to create a PDP policy that allows a group to view all food type transactions. The policy would need to say if column1='food' or column2='food' or column3='food' then allow Food group. I tried creating a policy for each column allowing the Food group but PDP is treating the policies as an AND and not displaying any data unless all columns on a row contain 'food'. I can create a second policy on column1 for column1='retail' and allow the 'food' group which will then create a policy of column1='food' or 'retail' allow Food group. Any ideas how I can apply PDP across multiple columns?
Thank you.