collection parameter

[mohammad_awadat]

i need help to how pass parameter type Collection

 

to query String

 

Collection test;

 

test.add(22222);

test.add(2223322);

test.add(22224562);

 

---------------------

 

in query

 

WHERE PATIENT_NO IN (TEST)

 

thank you

[vinays84]

If the parameter you pass in is of type collection, then you need to use $X{IN, param}.

So if you have a parameter called testCollection of type Collection, your SQL would be:

Code:

... 
WHERE PATIENT_NO $X{IN, testCollection} 
...

 

Alternatively, you can use Strings for everything and hard put the SQL. So if you had a parameter called testCollection of type String to which you pass in the value "22222,2223322,22224562", your SQL would be

 

Code:

[code]... WHERE PATIENT_NO IN ($P!{testCollection}) ...

[mohammad_awadat]

when use

WHERE PATIENT_NO $X{IN, testCollection}

display this error

-----------

SQL IN clause missing parameter token

--

when use

WHERE PATIENT_NO IN ($P!{testCollection})

display this error

-----------

Incompatible java.util.ArrayList value assigned to parameter test

 

may be you can help me

 

thank you

[vinays84]

For the former, I'm sorry, I provided you with the wrong syntax. It should be $X{IN, <column>, <param>}, so:

Code:

WHERE $X{IN,PATIENT_NO, testCollection}

 

For the latter, the parameter type must be String. So your backend java code would be:

Code:

[code] String testCollection = "22222"; testCollection += ",2223322"; testCollection += ",22224562";

This would all you to properly use

Code:

[code]WHERE PATIENT_NO IN ($P!{testCollection})

[mohammad_awadat]

thank you to much

this way is work

 

WHERE PATIENT_NO IN ($P!{testCollection})

[mohammad_awadat]

thank you to much

this way is work

 

WHERE PATIENT_NO IN ($P!{testCollection})