I have a document where some of the field names are uuids.
My query
SELECT *
FROM test AS d
WHERE d.orders.[0f17a3ac-addb-49e5-a687-b6124dfd371d].destination = “AAA”;
fails with incorrect syntax. What is the correct syntax for queries that include UUIDs ?
{
"firstname": "m",
"lastname": "bm",
"orders": {
"0f17a3ac-addb-49e5-a687-b6124dfd371d": {
"destination": "AAA",
"_created": "2020-01-09T16:50:41+00:00",
"items": [
"ink",
"paper",
"printer-paper"
]
},
"1f17a3ac-addb-49e5-a687-b6124dfd371d": {
"destination": "AAA",
"_created": "2020-01-15T16:50:41+00:00",
"items": [
"pencils",
"paper",
"markers"
]
}
},
"phone": {
"home": {
"areacode": "999",
"number": "9990000"
},
"mobile": {
"areacode": "111",
"number": "2223333"
}
}
}