Forum Discussion

JC25's avatar
JC25
Regular Visitor
2 years ago
Solved

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...
Need Help
Tips and Tricks
Tutorial Requests
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    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 needed

    3 - 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 Parameter

    2 - Add new column

    3 - Relationship between the two tables

    4 - Final Output

    I hope this can help you to solve your issue.

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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 needed

3 - 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 Parameter

2 - Add new column

3 - Relationship between the two tables

4 - Final Output

I hope this can help you to solve your issue.