#1. I do not know how the function beeing creted and the purpose. This is related to the database. I used to created so-called view / "method" to pass the value - but this is part of column name: SELECT mymethod(somevalue), column1, column2 FROM table. If you have problem on funtion, simple use the common SQL: SELECT column1, column2 FROM table WHERE column1 IN ($P!{PARAM2}) #2. Same as above. #3. My Param is String, so the output will be: 'value1', 'value2' You may change it to Integer and play around with replaceALL so that your output will be: value1, value2 (without quotes) #4. Then, you need to have the validation in the Parameter (if else clause)