Forum Discussion

IBK's avatar
IBK
New Contributor III
3 months ago

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

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...
User Interface
  • MarcusH's avatar
    MarcusH
    3 months ago

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

     

    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.

IBK's avatar
IBK
New Contributor III

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 

KarlT's avatar
KarlT
Contributor III
3 months ago

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,