How to use IN in SQL

[awinter17]

I was trying to use IN in SQL -  $X(IN, field, list)

Third parameter has to be list of something.

Base on documentation, it has to be collection.

How iist has to be set up?

How values could be added to the list?

[srang]

So it looks like you have the syntax right for the comparison in sql. Then set up a parameter with class Collection and then nested type name as whatever your list is made of (eg Integer). Then you can either define a static paramter on the server or define your list of available values from a query based input. You can also assign a default value for the list like so '(java.util.Collection)(Arrays.asList(1,2,3))'

[hozawa]

The third parameter should be a Parameter name. That parameter should be a Java list.

There's a sample in the page below

http://jasperreports.sourceforge.net/sample.reference/query/