johnny.cash Posted October 10, 2019 Share Posted October 10, 2019 Good Dayin 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 Link to comment Share on other sites More sharing options...
Solution danoldenkampgmail.com Posted October 10, 2019 Solution Share Posted October 10, 2019 You can use the class:java.util.ArrayList or java.util.Collectionare you passing the parameter to the element?Click on the element (let's say a table)Dataset > ParametersMake sure the paramater is selected in the expression. Link to comment Share on other sites More sharing options...
johnny.cash Posted October 10, 2019 Author Share Posted October 10, 2019 Thank you, Dan! You hit the nail on the head. The parameter was not known to the table element. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now