I am wondering if there is a way to use for example an ARRAY_CONTAINS to check if a value in a doc in an Array exists
I know i can check simple array but had no luck if the element in Array is a doc like
"myarray" : [ {"car": { "type" ; "basic", "model" : "bmw"}},{"car": {"type": "sport", "model" :"porsche:}} ]
i tried like ARRAY_CONTAINS(myarray.car.model, ‘bmw’) but with no luck