[json parsing engine and query syntax for JsonDataSource]

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.

 

[How to handle fields from a JSON data source that starts with an array?]

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."
         }
      ]
   }
]