How to query objects in array with multiple criteria in MongoDB?

Question

Here is my data

// Data 1
{
  name : 111, 
  factors : 
  [
    {name:"f1", value:"dog", unit : "kg"},
    {name:"f2", value:"0"},
    {name: "f3", value:"rain"}
  ]
},
// data2
{
  name : 112, 
  factors : 
  [
    {name:"f1", value:"cat", unit : "g"},
    {name:"f2", value:"13"},
    {name: "f3", value:"rain"}
  ]
}
// more data ...

I would like to find the one with f3=rain, and f1=cat.

I have tried

query = {
  factors : {
    $elemMatch : 
       [
          {name: "f1", value:"cat"},
          {name: "f3", value: "rain"}
       ]
},

But there is error saying, Error: error: { "$err" : "$elemMatch needs an Object", "code" : 12517 }

What should I do to construct that query?

Sede · Accepted Answer · 2016-05-18 05:36:51Z

2

You need to use the $and logical query operator

db.collection.find(
    { $and: [
        { "factors": { $elemMatch: { "name": "f1", "value": "cat" } } }, 
        { "factors": { $elemMatch: { "name": "f3", "value": "rain" } } } 
    ]}
)

edited May 18, 2016 at 5:36

Sede

61.5k20 gold badges158 silver badges162 bronze badges

answered May 18, 2016 at 4:54

Atish

4,4852 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ppn029012 Over a year ago

thx! p.s. do you think it is the optimal data schema for this kind of search? or is it better to make the schema as [{"f1" : "val12"},{f2: "val22"}] ?

Tejas R. Over a year ago

Can you please answer this question- stackoverflow.com/questions/67600862/…

Collectives™ on Stack Overflow

How to query objects in array with multiple criteria in MongoDB?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related