I was wondering if it was possible to be able to pull multiple sites from the lobby filter, i have a inventory elelement and right now i can filter one site at a time, and it loads into my element correctly, was wondering if there was a way to be able to add multiple site codes and have all those load into the elemenet.
This is something i am just testing so i dont have to have multiple lobbies for each individual. if its not possible it is not a big deal. Thank you for any time and help you can provide
Lobby FIlter i want to have multiple sites on
Lobby Element Sites would load To
Current Element SQL
Best answer by NickPorter
Syntactically that will be resolving into IN (‘C0158,C0152’) which is really just a single value in the quotes.
If they were just numbers you would drop the ‘ character completely (which is what I have in my example). That may not work for a list of values that are text strings but you could try it.
A simple workaround would be to enter the values as ‘C0158’,’C0152’ and also drop the ‘ in the expression that you have coded, so that it resolves to IN (‘C0158’,’C0152’) and will likely parse as you intend. Its a little clunky and there may be a better syntax but this should work for you
If the Site value is free text to be entered, I think you can enter multiple values with a separator, but the exact syntax is eluding me as I try to check with a similar example here.
Syntactically that will be resolving into IN (‘C0158,C0152’) which is really just a single value in the quotes.
If they were just numbers you would drop the ‘ character completely (which is what I have in my example). That may not work for a list of values that are text strings but you could try it.
A simple workaround would be to enter the values as ‘C0158’,’C0152’ and also drop the ‘ in the expression that you have coded, so that it resolves to IN (‘C0158’,’C0152’) and will likely parse as you intend. Its a little clunky and there may be a better syntax but this should work for you
i would like to suggest you that you can use below code in data source where you can pass multiple site with comma separated. hope it will addressed your query.
AND CONTRACT IN ( select regexp_substr('$SITE$','[^,]+', 1, level) from dual connect by regexp_substr('$SITE$', '[^,]+', 1, level) is not null )
