Making reports with nested JSON, JSONQL?

1

Hi, 

I've got a question about nested JSON/Multiple querries. 

I currently have a report using WebserviceQuerry that returns me a JSON. To get everything I need, I use a subreport, this passes to a subreport etc etc.
I'm wondering if this can be made more efficiënt?

For example: 

 Nested JSON

I can access hostid and name as I've set "result" as root path. But how can I access all the information under "items"? 
Jasperreports 6.3.1 supports JSONQL, can this somehow be used to access those fields? 

Should I go about it some other way? 

jb_3's picture
7
Joined: Jul 29 2016 - 1:31pm
Last seen: 3 years 3 months ago

Has your issue been fixed? Sitting with the same problem, only way I can get it to work in to add the value from the embedded obejct and put it in the parent node to add it as a field.

JeanBotha - 1 year 6 months ago

Hi,

I have the same scenarion. Can you please let me know if you got the solution for this. Please suggest how can I handle this scenarion.

shruti.kale - 5 months 3 weeks ago

1 Answer:

0

You should be able to achieve what you want with either JSON or JSONQL query languages. JSONQL has more features and is meant to replace JSON.

Your case looks similar to the ones described in the documentation for JSONQL datasource:

JSONQL: http://jasperreports.sourceforge.net/sample.reference/jsonqldatasource/i...

You can also grab the sample files from the github project: https://github.com/Jaspersoft/jasperreports/tree/jr-6-3-1/jasperreports/...

narcism's picture
1255
Joined: Nov 22 2010 - 12:39am
Last seen: 56 min 22 sec ago
Feedback
randomness