$X parameter not working

[johnny.cash]

Good Day

in a report I have a dataset with a query of this sort:

    SELECT stuff
    FROM table
    WHERE $X{IN, column, dm_parameter}

I have sucessfully used similar queries on a MSSQL database with the exact same WHERE clause.

I created a PostgreSQL datasource and run other queries on it successfully.

But when I run this query it returnes ALL rows, as if the WHERE condition would not exist.

The dm_parameter is of Class java.util.ArrayList.

Any ideas what I am doing wrong or how to troubelshoot it?

Thank you

[danoldenkampgmail.com]

You can use the class:

java.util.ArrayList or java.util.Collection

are you passing the parameter to the element?

Click on the element (let's say a table)

Dataset > Parameters

Make sure the paramater is selected in the expression.

[johnny.cash]

Thank you, Dan! You hit the nail on the head. The parameter was not known to the table element.