I am struggling a bit on how to do this via search instead of a “regular” query. My goal is to find a record where there is an matching element in an array based on 2 properties.
In “normal” query it would basically be(ignoring detils):
$match: {
Fields: {
$elemMatch: {
SomeID: ObjectId(
“62b4d1d79cbf0bed0fbe35ca”
),
Value: “test”
}
}
}
I want to find the record which has an element with a value = test but ALSO and id(or whatever) = xxxx
In c# LINQ terms: someArray.Find(x => x.ID == XXX && value == YYY)
I cannot seem to get this to work in Atlas Search when the value == YYY is the “non exact” match I am searching on. Of course I can find the record when I just search for the YYYY, but I cannot figure out how to use a “Should” with a “MUST” and force it to match the SAME element.
Example:
[
{
ID = 123,
Value = ABC
},
{
ID = 456,
Value = XXX
}
]
I want to only find records which have a “X” in the value but ONLY when the ID is also “123”. When I try to combine a MUST/SHOULD in a compound I always get the record above because MUST 123 us true(first item in the array) and SHOULD “X” is true(second item in the array) and so I get a true.
Short Version: It works in slower non-search mode I just cannot figure out the syntax for Atlas Search mode.
Any ideas?
