Need help on RLS - manage roles, multiple values from one column

[mimitan]

Hi, 

I would like to set up RLS with multiple values in the table filter, I tried this but it would not work:

[Column] = "Value1" && [Column] = "Value2"

Please help. thank you.

[Syndicate_Admin]

You can check this video, which clearly explains how to solve this issue.

I hope I can help.

Best regards

[mimitan]

Hi everyone,

thank you for alll your inputs. My aim was to have 1 role with 2 filtered values. 

The quick solution I got was to just separate roles and add one person to both roles so he can access two RLS.

Is it possible to have 1 role with 2 filters? for example column is countries, 1 roles for 2 countries?

[Anonymous]

@mimitan  Yes it is possible you can make use of my example
[Salescountry] IN  {IN,CN}-->Change IN & CN according to your data

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[Anonymous · Accepted solution]

@mimitan When you are trying to give logical operators in RLS filters AND,OR does not work you will have to make use of IN keyword
eg:[Salescountry] IN  {IN,CN,PH}
[Salescountry] ="CN" ||  [Salescountry] ="PH"

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[Burak35]

This is not working. I tried but it says syntax error

[amitchandak]

@mimitan , Try like

[Column] in { "Value1" , "Value2"}

Same time you can not have two different value true

[tex628]

Hi @mimitan 

The && is an "AND" operator and the example you're giving will never return true. 

[Column] can never be "Value1" AND "Value2" at the same time. 

Are you looking for the OR operator? It's "||"

/ J