multiselect input control + stored procedure

[phodges]

Most of our query text consists of stored-procedure calls, not selects and joins, etc. This mean that I do not need the $X{IN, expr, parameter} syntax as currently output by the multiselect control. What I need is a comma separated list of the selections from the control.

What is the best way to accomplish this?

--Paul

[ankurcpatel]

Hi Paul,

I am facing the same problem as you are. Did you find a solution to this problem? Any help you can provide would be most helpful.

Thank you,

Ankur

[mespub]

Hi,

If you have a PARAMETER1 as Collection, you can create a second parameter (not promptable) PARAMETER2 as STRING with  expression $P{PARAMETER1}

At this point you get a String and you can use java string methods like replace() to get away the brackets