Hello.I’ve seen some conversations/questions in Community about possibility to add multiple values in one lobby page parameter.Here, how I solved this thing in my configuration, SQL WHERE in Datasource Designer is a bit different than what I found.--------------------------------------------------ATTRIBUTE like DECODE(instr(',' || '$PARAMETER$' || ',', ',' || ATTRIBUTE || ','),0,nvl('$PARAMETER$','%'),'%')replace ATTRIBUTE with your attribute/column in datasource.replace PARAMETER with your lobby page parameter name.--------------------------------------------------For example if you need to have Purchase Group as parameter in lobby, defining datasource like this will allow user to add multiple values in one parameter. Values in parameter field to be separated with comma, and no spaces in between.STAT_GRP like DECODE(instr(',' || '$Purchase Group$' || ',', ',' || STAT_GRP || ','),0,nvl('$Purchase Group$','%'),'%')If NULL’s wanted to be included, just add OR STAT_GRP IS NULL .----------
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.