Forum Discussion

mimitan's avatar
mimitan
Regular Visitor
5 years ago
Solved

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

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.    
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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!!👍






mimitan's avatar
mimitan
Regular Visitor
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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!!👍