REST API & Collection parameters issue

[jyka.saario]

Hello!

I’m struggling with REST API (v2). Here is my case:

I need to pass parameters to my SQL query what uses SQL IN. I found several examples where this is explained.

In Jasper Studio (latest version), my parameter is named as ID_ARR. Param class is set to java.util.Collection (have tried List as well). Only name & class is set for parameter.

 

In SQL this is used like: where $X{IN, id, ID_ARR}

 

All works like charm when I use preview in my Jasper Studio.

 

Now I need to run this report via REST API request. This is URL for report:

http://localhost:8080/rest_v2/reports/Reports/TestReport.pdf?interactive=true&onePagePerSheet=false&freshData=true&saveDataSnapshot=false&ID_ARR=1469&ID_ARR=1470&ID_ARR=1471&ID_ARR=1472&ID_ARR=1473

 

Report will be returned just fine, BUT ID_ARR variable remains always empty and all data is returned from table, so where IN is not executed at all?

Any ideas what I’m doing wrong?

 

I use latest JasperStudio & Jasper Server (6.4.0)

[andrew.brooks_1]

Did you solve this issue?

 

I'm currently having the same problem but getting an error as the crosstab in the report is too large with all the results.

Cheers

Andrew

[aaron_17]

Was this ever worked out... I have the EXACT same issue.... Andrew did you ever figure it out?

 

Aaron

[anubha0408]

hi All,

 

I am having the same issue. Its working fine on JasperStudio but not on jasperserver. Has anyone resolved it ?

 

Regards

Anubha