$X parameter not working

0

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

johnny.cash's picture
Joined: Oct 10 2019 - 8:15am
Last seen: 1 month 2 days ago

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

johnny.cash - 1 month 2 days ago

1 Answer:

2

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.

danoldenkamp@gmail.com's picture
Joined: Aug 29 2018 - 11:12am
Last seen: 9 hours 27 min ago
Feedback
randomness