I have the below structure
Doc1:
{
"key1": "value1",
"key2": [
{
"subId": "id1",
"subKey1": "PASS"
},
{
"subId": "id2",
"subKey1": "PASS"
}
]
},
Doc2:
{
"key1": "value2",
"key2": [
{
"subId": "id1",
"subKey1": "PASS"
},
{
"subId": "id2",
"subKey1": "FAIL"
}
]
}
I want to search for doc in which inside "key2.subKey": "PASS" for all children inside the array. So the query in this case should just return Doc1