Skip to main content
I
IBK
October 16, 2024
Solved

Dynamically controlling the columns that are to be shown in the sql table editor

  • October 16, 2024
  • 2 replies
  • 0 views

Hello,

      We have a View Selection screen with users selecting the columns and the order they want to see as we have a  total of 136 columns to choose from.  This should happen on the 1st tab of the Dashboard. On the 2md tab the sql table editor has to show those columns and the order in which it has been chosen. Any insights on this would be appreciated. 

 

Thank You,

Indu

Best answer by MarcusH

You can use an XFBR Business Rule on the Column Format:


MarcusH_1-1729170680365.png

 

The XFBR string can take other parameters which you then process to create the format string that you would usually see here. To hide a column you can return:

IsVisible = False

I suppose you could save the column selections in a parameter on the 1st tab and read them on the second.

2 replies

M
MarcusHAnswer
October 17, 2024

You can use an XFBR Business Rule on the Column Format:


MarcusH_1-1729170680365.png

 

The XFBR string can take other parameters which you then process to create the format string that you would usually see here. To hide a column you can return:

IsVisible = False

I suppose you could save the column selections in a parameter on the 1st tab and read them on the second.

I
IBKAuthor
October 17, 2024

Hi Marcus,

  Thank You very much. That is an awesome way to get that done. One other problem I face is there are in total 130 columns that can be selected from but the Sql Table Editor in version 7.2.4 allows only 50. So only the first 50 columns will get the formatting if the users choose more than 50 columns.

-Indu 

K
KarlT
October 21, 2024

Hi Indu, 

The new dynamic dashboards functionality (v8.x and above) should allow you define the formatting of more than 50 columns through rules.

Regards,

Terms & ConditionsAccessibility statement