$X parameter not working

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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: 2 years 8 months ago

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

johnny.cash - 2 years 8 months ago

1 Answer:

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: 1 year 3 months ago