Passing sql query as a parameter in $X{} - jaspersoft studio 5.6.2

[vhp1990]

Hey,

     I would like to obtain the values for a 'where in' clause using a query. That is , for $X{IN, colName, parameter}, I want to provide the parameter as a query. In normal where conditions, we use $P!{} and pass the query as a string. In case of $X how do we do this ? Kindly help. Thanks in advance.

[srang]

So I'm not a hundred percent I understand your question but when I've used $X{} in the past what I've done is create a parameter of type Collection<Integer> (for primary keys) and then the WHERE statement becomes $X{IN, col, param} then in jasperserver when you define the parameter you can choose to use a query and specify a value column and a display column. This means that while working within studio you have to enter a list of ints instead of getting to use the query but in the server it all works seamlessly. I hope that helps answer your question!