JasperReports' Report Designer does not work with every json stream

[vgaikwad]

Hi,

I was trying out the JSON data adapter from JasperReports' Server 6.1. I understood that for simple json format the tool works just fine, but if the data is formatted as per the v1.0 specifiation of json then it does not work as expected.

 

This works:

[

{ "userId": 1, "id": 1, "title": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit", "body": "quia et suscipitnsuscipit recusandae consequuntur expedita et cumnreprehenderit molestiae ut ut quas totamnnostrum rerum est autem sunt rem eveniet architecto" },

{ "userId": 1, "id": 2, "title": "qui est esse", "body": "est rerum tempore vitaensequi sint nihil reprehenderit dolor beatae ea dolores nequenfugiat blanditiis voluptate porro vel nihil molestiae ut reiciendisnqui aperiam non debitis possimus qui neque nisi nulla" },

{ "userId": 1, "id": 3, "title": "ea molestias quasi exercitationem repellat qui ipsa sit aut", "body": "et iusto sed quo iurenvoluptatem occaecati omnis eligendi aut adnvoluptatem doloribus vel accusantium quis pariaturnmolestiae porro eius odio et labore et velit aut" }

]

 

But, this does not work:

 

{ "list":{"@type":"Patients","@record-count":"10",

"Patients": [

{"@code":"1","@fname":"rajesh","@lname":"gulati","@gender":"m","@caregiver":"1"}, {"@code":"2","@fname":"ramesh","@lname":"vohra","@gender":"m","@caregiver":"1"}, {"@code":"3","@fname":"lalit","@lname":"papad","@gender":"m","@caregiver":"1"}, {"@code":"4","@fname":"vinod","@lname":"pandey","@gender":"m","@caregiver":"1"}, {"@code":"5","@fname":"alka","@lname":"talati","@gender":"f","@caregiver":"2"}

] } }

 

The domain query builder just fails with an exception. Are there ways to do a json query and select specific parts in data? -Vaibhav