rlothai

Hello, this is a bump with a more specific question. Assuming an object array with an embedded object array, like this: "sections": [{ "id": "section-Id-One", "property-One": true, "fields": [{ "id": "field-Id-One", "property-One": false, "property-Two": true, ... }, { "id": "field-Id-Two", "property-One": false, "property-Two": true, ... } .....I have succeeded in getting a query like this to work: sections(id == section-Id-One) But I cannot go deeper into the object graph, like:sections(id == sectionId).fields(id == field-Id-One)Seems nested arrays are a challenge. But I have a structure I cannot change and need to get at the properties. Is this supposed to work? Also, it would be great if someone just said, "oh, JSON queries in the datasource work like X or Y", or maybe "don't use this datasource because it's unfinished." Perhaps it's still too new, but I think it is an attractive option.

Hello, I want to use the JsonDataSource in our bank project and have begun experimenting with it in iReport, with some success. Does anyone know if there is a third-party parsing engine being used or is this home grown? I could not glean the answer from a short look at the code. I need to locate a more or less complete reference for the query syntax, as I will be doing complex logic for some fields. I can so far grab values from within my own JSON string using syntax like: sections[0].fields[0].value in my fielddescriptions. I really need to be able to look for specific values of the keys for objects in an array, but cannot figure out what that syntax should look like. Later I will also need to show or hide fields based on boolean values stored with the fields (are functions available, and how?). I downloaded and got the JSON example working with the queryString syntax in the orders report: Northwind.Orders(CustomerID == $P{CustomerID} and was hoping to use something similar. So far I can't get the queryString to work with a similar lookup in my own json, and the == does not seem to work in fields either (not sure they are supposed to in fields, as not only can I not find documentation but I am also new to Jasper). While I can give you example JSON and have you solve the problem, what I would prefer is a link to some decent documentation I can digest and use myself. Thanks in advance and looking forward