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






7 Replies

  • 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

  • tex628's avatar
    tex628
    Community Champion
    5 years ago

    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

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    mimitan , Try like

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

     

    Same time you can not have two different value true

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

       

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

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

    I hope I can help.

    Best regards