Forum Discussion

NoorMohd's avatar
NoorMohd
New Contributor
12 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 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
    12 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

     

11 Replies

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    12 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
      12 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
        Icon for OneStream Employee rankOneStream Employee
        12 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? 

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    12 months ago

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