lee.irvine
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by lee.irvine
-
-
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."
}
]
}
]
json parsing engine and query syntax for JsonDataSource
in Products
Posted
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.