Forum Discussion

jessimica1018's avatar
jessimica1018
Helper II
2 years ago

RLS with multiple columns

Hey!  I am in need of help with a RLS issue and filtering data. We have used bookmarks/buttons to help seperate Seller, Admin, and Manager sales amounts (parameters didn't work due to blank Admin ce...
Need Help
sergej_og's avatar
sergej_og
Super User
2 years ago

Not sure to have catched it right.
Do you have already implemented/defined RLS groups (Desktop) and maybe assigned users to these groups (in Service)?

Regards

  • jessimica1018's avatar
    jessimica1018
    Helper II
    2 years ago

    We did try that already, having seperate groups but it still displays the same result over stating the sales. Since the user can be in multiple groups it keeps pulling data that isn't relevant to them in one category but is in another category.

    • sergej_og's avatar
      sergej_og
      Super User
      2 years ago

      Just copied your data above and tried to set RLS.
      Result:

      RLS is set up this way:


      Regards

      • jessimica1018's avatar
        jessimica1018
        Helper II
        2 years ago

        This may be a stupid question, we did try that method but the user can't choose their role correct?

        So when both roles are selected you will get the results I was getting before. We added buttons to try and seperate the two roles but still not effective at seperating the roles (parameters didn't quite work either).