N1QL Access different indices of Array in JSON
I have a bucket of JSON documents. They are heterogenous documents with different items. Each document is an array with different objects. I need to select all objects of the array that satisfied certain criteria. I realize that you defined "OVER" keyword to iterate the collections. But I am not able to use it in my exercise and I only get the results when I specifically define the index.
FROM newtest_bucket.`array` As g Where `myfield` IS Not MISSING
If I dont define , I will not get any results. Even when I try "OVER"
Really appreciate your comments.