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 .
--------------------------------------------------
SQL WHERE clause like this also allows all results when parameter field is empty.
-Simo