Multi select query with postgres sql

0

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 m.id IN ($1).....
The sql definition in my report is:
... WHERE $X{IN, m.id,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?
Thanks
csrinaldi's picture
Joined: Jan 15 2008 - 10:43pm
Last seen: 4 years 1 month ago

Any idea?

csrinaldi - 5 years 7 months ago

0 Answers:

No answers yet
Feedback