Forum Discussion

IBK's avatar
IBK
New Contributor III
2 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 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

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

    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
      2 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,

  • MarcusH's avatar
    MarcusH
    Contributor III
    2 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.