SQL_Table Editor

[NoorMohd]

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 

[SH_INT]

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]

Thank you so much for your response.

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

[TheJonG]

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]

Hi ,

Thanks for the response .

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

[TheJonG]

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.

[SH_INT · Accepted solution]

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

[NoorMohd]

Thanks a lot now I am achieve the requirement 

[SH_INT]

That works for me. What OS version are you using?

[NoorMohd]

OneStream 8.2.2

[SH_INT]

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

[NoorMohd]

Still the same