Forum Discussion
Showing different table column name based on viewer roles
I am trying to show different column name for different viewer roles. I have a column in a table named ABC. I want to make it so that when I pick User 1 and User 2, the column header will be ABC, but when I change the viewer role to other roles e.g. User 3 the column header will change to XYZ. Is there a way to do this?
Hi JC25,
I think it's possible to solve this problem using field parameters.
1 - Create a field parameter with the two columns that you want.
2 - Add a new column on your usernames/roles table that you are using to apply the RLS and classified each username with the number of the order parameter (created on the first step) according your needed3 - Link the Parameter table with the usernames/roles table
4 - Use the parameters filed on the matrix instead of the column.
I did a quick example, please take a look:
1 - Field Parameter2 - Add new column
3 - Relationship between the two tables
4 - Final Output
I hope this can help you to solve your issue.
2 Replies
_AAndradeResident Rockstar
Hi JC25,
I think it's possible to solve this problem using field parameters.
1 - Create a field parameter with the two columns that you want.
2 - Add a new column on your usernames/roles table that you are using to apply the RLS and classified each username with the number of the order parameter (created on the first step) according your needed3 - Link the Parameter table with the usernames/roles table
4 - Use the parameters filed on the matrix instead of the column.
I did a quick example, please take a look:
1 - Field Parameter2 - Add new column
3 - Relationship between the two tables
4 - Final Output
I hope this can help you to solve your issue.