Multi select query with postgres sql

[csrinaldi]

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).....[/code]

 

The sql definition in my report is:

... WHERE $X{IN, m.id,motivos} ....[/code]

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]

Any idea?