How are multi-select menu values passed
We are using Oracle Business Intelligence 11.1.1.7.140225 with BIP integrated.
I need to know how multi-select menu type parameter values are passed to the bind variable inside the queries?
For example: Select ItemNbr from item_table where ItemNbr in (:pItemNbr).
If I have a menu parameter (that is of course based on a LOV Query) and I have set the "Multiple Selection" option to true, when I select multiple items in the list, how is the list actually sent to the sql statement in data model?
If I have three items in the list:
1
2
3
And say I select items 2 and 3. When the sql executes, will the bind variable be filled in with a comma delimted list of the selctions? LIke '2,3'? Or are the values passed as an array of strings? I thought it would be filled in as a comma delimited list, but it seems like it might be passed as an array of values?