Search several value in array

Working with Data
1

Hello, how i can find several value in array? Example:

  "specifications" : {
         "children" : [
             {
                 "name" : "brand", 
                 "val" : "brandName"
             }, 
             {
                 "name" : "series", 
                 "val" : "seriesValue"
             }, 
             {
                 "name" : "object", 
                 "val" : "objectVal1, objectVal2, objectVal3, objectVal4, objectVal5, objectVal6"
             }
         ]
     }

need find brandName + seriesValue + regexp objectVal3

I try simple test

{ $elemMatch: { $in: [ { name: “object”, val: { $regex: /objectVal3/gi } } ] } }

but not work

2

Hello @gotostereo_N_A,

You don’'t need the $in to specify multiple fields with $elemMatch. The following query filter will work:

{ "specifications.children": { $elemMatch: { name: "object", val: { $regex: /objectVal3/i } } } }

1 Like