How to compare constant value with multi value parameter in Jasper?

0

Hi,

I have a paramter named as param_multi. I would like to add this as part of my sql as follows:

Select * from employee where  184 in ( $P{param_multi} ).

Can anyone suggest on how to do this?

Thank you

Regards

Gowtham

gowthamsenmca's picture
Joined: Oct 15 2013 - 4:52am
Last seen: 2 years 11 months ago

Check my answer below and If it works Up Vote.

rajesh.sirsikar - 4 years 9 months ago

1 Answer:

1

Use

 

Select * from employee where $X{IN,184,param_multi}

Thanks

Rajesh Sirsikar

rajesh.sirsikar's picture
Joined: Apr 21 2014 - 5:43am
Last seen: 1 year 4 months ago
Feedback