I have this document stored in the DB
"data": {
"hostel": [
{
"countryHostel": {
"nif": {
"id": "987654321"
}
},
"name": {
"valueDescription": {
"defaultName": "GuestHouse"
},
"value": "2"
}
},
{
"countryHostel": {
"customerIdentifier": {
"id": "3456789"
}
},
"name": {
"value": "2"
}
},
"id": "1",
...
That I want to retrieve using this query,
SELECT ARRAY {r.data.hostel} as hostels FROM hostels r where r.id = ‘51’
but I have an error:
“msg”: “syntax error - at hostel”,