Hi, mongodb team.
Examples are as follows.
test data
[
{"_id": 1, "tags": ["A", "B", "C"]},
{"_id": 2, "tags": ["A"]},
{"_id": 3, "tags": ["B", "C"]},
]
The things I want are as follows.
MQL query
{
"$match": {
"tags": {"$not": {"$all": ["A", "B", "C"]}}
}
}
= selected 2, 3 documents
But in atlas
Search Query
{
"$search": {
"compound": {
"mustNot": [
{"equals": {"path": "tags", "value": "A"},
{"equals": {"path": "tags", "value": "B"},
{"equals": {"path": "tags", "value": "C"},
]
}
}
}
= empty documents
The mongodbatlas search operation only provides in or equals, so it seems difficult to search the same as MQL.
Is there any solution or other way of expressing this problem?
I would appreciate your help.