BI Publisher (MOSC)

MOSC Banner

How are multi-select menu values passed

edited Jul 16, 2014 5:05PM in BI Publisher (MOSC) 8 commentsAnswered


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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center