Query for Partial Object in Array - MongoDB

Question

I have a simple structured document like this:

"people" : [
    {
        "id" : "6241863",
        "amount" : 5
    }
],

People can contain more than one element. I've managed to get this to work:

db.village.findOne({"people": {"$in": [{"id": "6241863", "amount": 5}]}})

But I want to ignore amount and search for any document containing people with id 6241863 and any amount.

you can't retrieve part of array of single document in find query. you must do it in client side — Ravi Khakhkhar
– Ravi Khakhkhar, Commented Jul 10, 2012 at 14:50
dude how did u save the data like that , i have a shema like this product_video:[{thum_src:String,video_name:String,video_path:String}] and i dont know how to save the data — paynestrike
– paynestrike, Commented Dec 7, 2012 at 0:54

jmikola · Accepted Answer · 2012-07-10 16:04:35Z

5

According to the advanced query documentation, you can mix array value queries with dot notation for reaching into objects. Here's an example using your schema:

$ mongo
MongoDB shell version: 2.1.0
connecting to: test
> db.users.save({_id: 1, friends: [{id: 2, name: 'bob'}]})
> db.users.find({friends: {id: 2, name: 'bob'}})
{ "_id" : 1, "friends" : [ { "id" : 2, "name" : "bob" } ] }

> db.users.find({'friends.id': 2})
{ "_id" : 1, "friends" : [ { "id" : 2, "name" : "bob" } ] }

> db.users.find({'friends.name': 'bob'})
{ "_id" : 1, "friends" : [ { "id" : 2, "name" : "bob" } ] }

> db.users.find({'friends.name': 'ted'})
>

answered Jul 10, 2012 at 16:04

jmikola

6,9222 gold badges33 silver badges66 bronze badges

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

1 Comment

Big Money Over a year ago

How would you go about doing this if there was an object above users, such as roles that contained users and admins, and you still wanted to search just users?

golja · Accepted Answer · 2012-07-10 14:56:07Z

0

Try with that

db.village.findOne({"people" : { "$in" : [{ "id" : "6241863" , "amount" : { "$ne" : null } }]}})

answered Jul 10, 2012 at 14:56

golja

1,0938 silver badges11 bronze badges

Collectives™ on Stack Overflow

Query for Partial Object in Array - MongoDB

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related