I am working with a document similar to the following. I am trying to figure out how to return a list of the keys for the nested docs under tools. I cant seem to figure it out. I could restructure the doc to use an array get the information that way but I would much rather use this style.
something like
select b.tools.meta() from myBucket b USE KEYS “myDoc”
Any help would be appreciated. Thanks
[
{
“myBucket”: {
“tools”: {
“Jim”: {
“active”: false,
“ready”: false
},
“John”: {
“active”: false,
“ready”: false
}
},
“type”: “myDoc”
}
}
]