I have column chars
with such data:
"chars": [
{
"count": 1,
"color": "red"
},
{
"count": 2,
"color": "green"
},
{
"count": 3,
"color": "blue"
}
],
I filter by
{"$or":[{"chars.count":{"$ne":2"}},{"chars.color":{"$ne":"blue"}]}
or
{{"chars.count":{"$ne":2"},"chars.color":{"$ne":"blue"}}
I want to reveive object, but receive empty set.
I use MongoDB 6.0.6