Forum Discussion

anouar_aicha's avatar
anouar_aicha
New Contributor
6 months ago

Dynamic Delimited List Parameter in SQL Editor Based on Another Input Parameter

Hi OneStream Community, I hope you are all doing well. I am currently working on a project where I need to create a dropdown in a specific cell within the OneStream SQL Editor, and the values for...
User Interface
  • FredLucas's avatar
    FredLucas
    6 months ago

    Hi anouar_aicha,

    I'm afraid you can't set up a sql editor drop down parameter that shows different selection / options by row based on the content of other columns.
    You could however have the country being a filter outside of the sql editor and have that dynamically populating the delimited list you see (for ALL visible rows).

    I'm sorry this is not the answer you were probably hoping for.

    You can always suggest this enhancement as part of IdeaStream.

FredLucas's avatar
FredLucas
Contributor III
6 months ago

Hi anouar_aicha,

I'm afraid you can't set up a sql editor drop down parameter that shows different selection / options by row based on the content of other columns.
You could however have the country being a filter outside of the sql editor and have that dynamically populating the delimited list you see (for ALL visible rows).

I'm sorry this is not the answer you were probably hoping for.

You can always suggest this enhancement as part of IdeaStream.