Multi select query with postgres sql

I have a report with one input parameter of type Multi Select Query. The datasource that I'm using is Postgres Datasource.

The control input show fine, and, I select the values without problem but the value selected is not fill in the sql statement , by example:

..... WHERE IN ($1).....
The sql definition in my report is:
... WHERE $X{IN,,motivos} ....
So, the error is a cast error (integer = varcharing ). For my, jasperserver not fill the value in the statement with the config value (column value) in the input control definition.
Any idea?
csrinaldi's picture
Joined: Jan 15 2008 - 10:43pm
Last seen: 1 year 10 months ago

Any idea?

csrinaldi - 9 years 8 months ago

0 Answers:

No answers yet