Forum Discussion

NoorMohd's avatar
NoorMohd
New Contributor
2 years 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 achieve that requirement however it does not work even tough i follow the instruction given in the document.

Below are the screenshot of my datatable and parameters.

 

 Kindly help me to achieve this requirement .

 

Thank You 

 

 

Application Properties
Extensibility
Infrastructure
User Interface
  • SimonHesford's avatar
    SimonHesford
    2 years 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

     

11 Replies

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    2 years 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
      2 years 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
        2 years 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? 

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    2 years ago

    can you set the AllowUpdates property for the column to True that should fix it