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






Anonymous's avatar
Anonymous
Not applicable
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!!👍






Anonymous's avatar
Anonymous
Not applicable
2 years ago

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