jb_3 Posted April 13, 2017 Posted April 13, 2017 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: 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?
narcism Posted April 19, 2017 Posted April 19, 2017 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/index.html#jsonqldatasourceYou can also grab the sample files from the github project: https://github.com/Jaspersoft/jasperreports/tree/jr-6-3-1/jasperreports/demo/samples/jsonqldatasource
JeanBotha Posted January 9, 2019 Posted January 9, 2019 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.
shruti.kale Posted February 14, 2020 Posted February 14, 2020 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.
vedantv_hgc Posted April 25, 2022 Posted April 25, 2022 I got across similar problem, what is the JSONQL to fetch all the fields? Especially parent fields and child fields both.Example- I want to select hostid, name, itemid and type
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now