Collections and Rest API URLs

Good afternoon

I have a report with a parameter that is a java.util.Collection that runs fine in Jaspersoft Studio.

These is to go into the where clause of my SQL query.

I have uploaded the report to Jasperserver but am unable to test as it want's me to search and select values isntead of typing in manually.

When trying to run the report through the REST API, I can add the parameter to the URL, but it doesn't seem to get passed to the report, and the report tries to run without the where clause and all my data is returned.

Any ideas why this might be?

Cheers

andrew.brooks_1's picture
Joined: Jul 25 2017 - 2:13am
Last seen: 3 years 1 month ago

3 Answers:

Update to this.

I now have this partially working through the API, the only issue is that it will only work if I'm passing more than one value into the collection parameter.

I can workaround this by adding an extra blank value to the query (see example below):

localhost:8080/jasperserver-pro/rest_v2/reports/reports/test_5.pdf?jobs=18-39222&jobs=

 

Has anyone else experienced this, and found a fix?

 

Regards

Andrew

 

 

andrew.brooks_1's picture
Joined: Jul 25 2017 - 2:13am
Last seen: 3 years 1 month ago

yes this is the only way for Jasper Report 7.1 

 

there is no proper documentation/api method details 

vinothm2k's picture
555
Joined: Dec 16 2018 - 11:20pm
Last seen: 4 years 4 weeks ago

I know this is a pretty old problem, but I'm currently facing the same problem with Jaseper Version 7.8.0.

Even if I pass multiple values to my collection it wont work and resolves in an error.

Can anybody help? I've already created an articel ( https://community.jaspersoft.com/questions/1186721/report-parameter-list)

florian.weihl's picture
Joined: Aug 9 2021 - 11:44pm
Last seen: 1 year 9 months ago
Feedback