CODEWITHSUNDEEP
mongodbmongoosemongodb-query
Kankan-0
Kankan-0

Reputation: 463

Explanation of mongo query with OR condition

I have this data in my db

{ "_id" : ObjectId("5c89da093180684aba34c5b7"), "name" : "Allen", "age" : 24, "nicknames" : [ "kanky" ], "siblings" : [ ] }
{ "_id" : ObjectId("5c89da4b3180684aba34c5b8"), "name" : "Sonata", "age" : "30" }
{ "_id" : ObjectId("5c89da8f3180684aba34c5b9"), "name" : "Kaushik", "age" : "20" }
{ "_id" : ObjectId("5c89da8f3180684aba34c5ba"), "name" : "Stuart", "age" : "24" }
{ "_id" : "5c89da093180684aba34c5b7", "name" : "Allen", "age" : 24 }

When I run this query db.people.find({$or: [{name:"Allen"}, {age:24}]}), it doesn't give the entry with name : Stuart which has age : 24.

But if I run this query db.people.find({$or: [{name:"Stuart"}, {age:24}]}), it works as intended.

Can anyone explain how does this work? I am starting with mongodb, so mightbe a very basic question.

Thanks

Upvotes: 2

Views: 39

Answers (1)

cEeNiKc
cEeNiKc

Reputation: 1318

You have different schema types for age in different documents. For Allen you are using a number data type for age and for Stuart you are using a string to store age. I think thats the problem.

Try running this:-

db.people.find({$or: [{name:"Allen"}, {age: "24" }]})

You will get Stuart with this query. I don't see anything else wrong here except for different data types.

Upvotes: 1

Related Questions