Hi,
I have a problem with passing values from a input control to an other. In particolar the first input control PARAM1 is a multi-select query (type: java.util.Collection) and it returns the following value: [11,22,33]. The values are integer ! Now, this values enter in the query in the second input control like this $X{IN,cast(attribute(integer) as varchar(255)),PARAM1}. This expression work in the query report, but don't in the query of the input control? Why? Is there the possibility to transform the PARAM1 type from java.util.Collection to java.util.String? This could solve the problem. There is someone who can help me? Thank you very much.
3 Answers:
java.lang.Integer should work for multi select parameter.
I have tested. by inputting integer values to select mutlple. ( Where we generally assume mutli select should take collection but with integer values we have to take java.lang.Integer for parameter instead java.util.Colleciton).
from 4.7 and greter versions this supports. . We need not to cast in WHERE clause syntax of multi select.
Thank you.
Sadakar
