Hi community,
I’m trying to achieve a goal that I need to query an embedded document with mustNot in an embeddedDocument.
The structure could looks like:
{
clothesTag: [
{
style: "CASUAL",
priceRange: "LOW",
category: "SHIRTS"
}, {
style: "OFFICIAL_CASUAL",
priceRange: "LOW",
category: "TOP"
}
]
}
Query Example:
{
embeddedDocument: {
path: "clothesTag",
operator: {
compound: {
mustNot: [
{
wildcard: {
query: "OFFICE_CASUAL",
path: "clothesTag.style",
allowAnalyzedField: true,
}
}
]
}
}
}
}
I would like to get clothings with the tag not include the OFFICE_CASUAL.
However, with above query, atlas search is returning the one which also contains OFFICE_CASUAL because there are other elements in the clothesTag array which does not equal to this style.
It’s like atlas search evaluate this query in the way that as long as there’s one element in clothesTag array which does not contain the query value,
it’s consider as true and returned.
Are there any suggestions on how I could achieve the goal that only when none of the clothesTag contain OFFICE_CASUAL will that document get returned?
Thank you!