i have multiple documents with a field containing an array : for example:
"person1" : [
{
"network" : "A"
},
{
"network" : "B"
},
]
"person2" : [
{
"network" : "A"
},
{
"network" : "C"
}
]
i want to look for all the people without network C. (only person1)
if i query with { "must_not" : [{ "match": { "network" : "C" } }
i get also the person2. (because there is a subDoc in the array that does not have network C)
how can i query that all elements in array will match my condition