Category: | Bug report |
Priority: | Normal |
Status: | New |
Project: | Severity: | Minor |
Resolution: | Open |
|
Component: | Reproducibility: | Always |
Assigned to: |
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.
1 Comment:
add a Nested Type Name java.lang.Integer to a your parameter in Jasperreports (CountryList in your case).