Forum Discussion

NoorMohd's avatar
NoorMohd
New Contributor
1 year ago
Solved

SQL_Table Editor

Hi All,   I have trying to get the Combobox type of drop down in the custom created data table . https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Presentation/SQL%20...
Application Properties
Extensibility
Infrastructure
User Interface
  • SimonHesford's avatar
    SimonHesford
    1 year ago

    Yep, I agree that will cause an issue because the editor won't know which field to apply the formatting to in the table. NoorMohd maybe it would be worth a review of the SQL Editor component documentation in the OS guides as this is a basic configuration step

     

SimonHesford's avatar
SimonHesford
Contributor II
1 year ago

Hi,

Once you have set up a parameter that returns a list you just need to associate it with the relevant column in your SQL Table Editor component

 

 

NoorMohd's avatar
NoorMohd
New Contributor
1 year ago

Thank you so much for your response.

I have created a Delimited list parameter and did that as well but still no response.

 

  • TheJonG's avatar
    TheJonG
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    Your Default Value is 'F' and is not contained in the delimited list of values. That may be the issue. If not, can you show a screenshot of the SQL table properties? 

    • NoorMohd's avatar
      NoorMohd
      New Contributor
      1 year ago

      Hi ,

      Thanks for the response .

      I have changed my default value to F to FC Still it has the issue.

       

      • TheJonG's avatar
        TheJonG
        Icon for OneStream Employee rankOneStream Employee
        1 year ago

        You have not defined the ColumnName property for Column2. That may be the issue because it doesn't know which column to apply the parameter to.