Collection and dynamic query

[dec]

Hello,

 

I create a query with one dynamic parameter : select nom,prenom from patient $P!{COND2}

I've a parameter COND1 (String) use as a prompt, COND2 is not promptable, the default value expression is : ( $P{COND1}==null ? "" : " where nom ='"+$P{COND1}+"'")

COND2 as string, it works

Now, I want transform COND1 as a collection, i try with a in clause in COND2 parameter, it didn't work, please, help me to solve this.

[cjasper]

Create a java class which takes your string as input parameter  and returns any collection/list. call that method to convert your string to collection.

[dec]

I solve this by using methad .toList

Thks

[dec]

Solve by using toList method.

Thks