lee.irvine

If I change the JSON to something like: "sections": [{ "id": { "myid" : "section-Id-One" }, ... The Search doesnt seem to work anymore: sections(id.myid == section-Id-One).fields(id == field-Id-One) Does it support this kind of query in the JsonPath used in JasperReports as in XPath this is a standard lookup.

A valid form of a JSON document begins as an Array element. How do you access any element using the JsonDataSource "jsonpath" to query it? I have tried using the standard $[0] for the top level fields and as "$" for creating my subdataset but neither works... when I place the array under a standard element it works fin,e but that is not the format of our JSON. My JSON loks a bit like this: [ { "race": { "raceId": "1.33.1141109.2", "startDate": "2014-11-09T13:15:00.000Z", "raceClassification": { "classification": "Novices'" }, "raceType": { "key": "H" }, "raceClass": 4, "course": { "courseId": "1.33" }, "meetingId": "1.33.1141109" }, "numberOfRunners": 2, "runners": [ { "horseId": "1.00387464", "trainer": { "trainerId": "1.00034060" }, "ownerColours": "Maroon, pink sleeves, dark blue cap." }, { "horseId": "1.00373620", "trainer": { "trainerId": "1.00010997" }, "ownerColours": "Black, emerald green cross of lorraine, striped sleeves." } ] }, { "race": { "raceId": "1.33.1141109.3", "startDate": "2014-11-09T13:45:00.000Z", "raceClassification": { "classification": "Handicap" }, "raceType": { "key": "C" }, "raceClass": 4, "course": { "courseId": "1.33" }, "meetingId": "1.33.1141109" }, "numberOfRunners": 2, "runners": [ { "horseId": "1.00297339", "trainer": { "trainerId": "1.00000577" }, "ownerColours": "Maroon and light blue (quartered), maroon sleeves." }, { "horseId": "1.00333030", "trainer": { "trainerId": "1.00000065", }, "ownerColours": "Emerald green, yellow hoops, white cap." } ] } ]