3 weeks ago
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
Solved! Go to Solution.
3 weeks 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
3 weeks 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
3 weeks ago
Thank you so much for your response.
I have created a Delimited list parameter and did that as well but still no response.
3 weeks 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?
3 weeks ago
Hi ,
Thanks for the response .
I have changed my default value to F to FC Still it has the issue.
3 weeks 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.
3 weeks 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
3 weeks ago
Thanks a lot now I am achieve the requirement
3 weeks ago
That works for me. What OS version are you using?
3 weeks ago
OneStream 8.2.2
3 weeks ago
can you set the AllowUpdates property for the column to True that should fix it
3 weeks ago
Still the same