In my Java program I selected a list of values and wanted to pass this list to iReport as a parameter. This parameter would be used in the SQL query: SELECT ... FROM ... WHERE ... IN ($ P {list})
When I pass a code it only works like where = $ P {code}
But I want to pass several codes at the same time how do I do this?
I tried it List codes = new ArrayList (); codigos.add (1); codigos.add (2); codigos.add (3);
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("codigo", codigos);
But it did not work
I tried to pass a string type "1,2,3" and tb did not work