RLS - more than 1 item in a column

[dniedrauer]

Hopefully, the title explains it simply enough. This really isn't complicated, but it's frustrating. 

1. I want to implement row level security for a table with the following columns

Customer_ID

Brand

Payer Name

Customer Group

Payer name includes 7 different items. I want to include only two of them in the filter. 

I have tried: 

[Customer All Payers] = "Holland America-T" && "Holland America-P" and it doesn't work. However, [Customer All Payers] = "Holland America-T" works, but I need this group to be able to see both of them. 

Please, how do you use an "or" type construction in an RLS filter. 

[TomMartens · Accepted solution]

Hey,

use this

[Customer All Payers] IN {"Holland America-T", "Holland America-P"}

and be aware of the curly braces

Regards

[dniedrauer]

Hi, 

Thank you. That worked and so did ||

Appreciate the quick help.

[TomMartens]

Hey,

good that you also figuered out another solution for your question.

Please do not forget to mark a post as answer, that will help others.

Regards