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

Posted on November 19, 2014 at 1:41am

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

Joined: Oct 15 2013 - 4:52am

Last seen: 7 years 3 weeks ago

Check my answer below and If it works Up Vote.

rajesh.sirsikar - 8 years 10 months ago

1 Answer:

Posted on November 19, 2014 at 9:33am

Use

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

Thanks

Rajesh Sirsikar

2119

Joined: Apr 21 2014 - 5:43am

Last seen: 5 years 5 months ago