Hi I have a quicksight dataset which I use for applying RLS. This file has a groupname which is the group assigned for each client and then the id for that client .
I have a filter ‘Client’ which gives a dropdown for all the clients. If I am one of the client, I want to hide this filter . If I am an admin , then I should be able to see all the options.
I was using dynamic default with the quicksight dataset as shown below. I dint set any default value .
I set the rule as if the idsite has 4 in it, then hide this control . Since admin group has no idsite set .:-
But when I apply this, it hides filter for admin as well.
How Do I make sure that filters are applied as per the user logged n ?
Hi @liya101,
If you have RLS setup, the non-admin user should only see the client name that they are associated with in the dropdown. Are all client names showing in the dropdown for non-admin users?
Alternatively, in the dynamic default editor you shared above, I see that you entered the m_idsite value in for your user name, group name, and default value dropdowns. Does that field map to the group names that you are using within Quick Sight? If so, you can leave it as the Group name column, but then you should leave the user name column blank. That is for the actual user name of the Quick Sight user viewing the dashboard.
