[#5655] - Is param1 of 'Input Control' $X{IN, param1, param2} must be a string ?

Category:
Bug report
Priority:
Normal
Status:
New
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

I tried to create multi-select query in ireport before uploading to jasperserver repository.
<parameter name="CountryList" class="java.util.Collection"/>
<queryString><![CDATA[
SELECT * FROM Orders WHERE $X{IN, ShipCountryID, CountryList}
]]></queryString>

Running the report generated an error. ie.
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.

ShipCountryID is a integer.

chenny's picture
13
Joined: Oct 9 2007 - 1:15pm
Last seen: 7 months 4 weeks ago

1 Comment:

#1
  • Assigned:nobody»

add a Nested Type Name java.lang.Integer to a your parameter in Jasperreports (CountryList in your case).

Feedback
randomness