Forum Discussion

NoorMohd's avatar
NoorMohd
New Contributor
9 months ago
Solved

SQL_Table Editor

Hi All,   I have trying to get the Combobox type of drop down in the custom created data table . SQL Table Editor Searchable Drop-Down List (onestream.com) The above link the documentation to...
Application Properties
Extensibility
Infrastructure
User Interface
  • SimonHesford's avatar
    SimonHesford
    9 months 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
9 months 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
9 months 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
    Contributor III
    9 months 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
      9 months 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
        Contributor III
        9 months 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.