ArrayList Parameter for query

[fabridp]

Hello all,

I pass to the report a parameter "list" of type arraylist.

Ho can I utilize it in query for stamente

WHERE FIELD IN (elements of list)

?

 

Thanks in advance

[lukus]

Hi There,

 

I'm using a JasperFillManager.fillReport to create the report.  To make this work I am passing in a hashmap.

 

eg.

Create the parameter in iReport or your XML doc (in this case 'ITEM_ID')

Map parameters = new HashMap();
parameters.put('ITEM_ID', '15846');
JasperFillManager.fillReport(jasperReport, parameters, dataSource);

 

When this is done your parameter should be available for use in your query at report launch time.  You can reference it like this...

 

SELECT item, otheritemdetail

FROM items

WHERE id = $!P{ITEM_ID}

 

Be sure to include the '!' in the parameter reference or else it will enclose its value in "".

 

Hope this helps.

 

 

Code: