mongodb find single embedded document as an object not as an array

Question

I wonder if there is a way to get a single object instead of an array when querying for a single embedded document in MongoDB

I have Groups with embedded Users

{
 groupname: "Admins",
 users: [
    { 
        email: [email protected], 
        first_name: 'bob'
    },
    {...},
    {...} // multiple embedded users
 ]
}

I can query a single user from a group with this query

db.groups.find({'users.email' => [email protected]}, {'users.$' => 1})

but it gives me a 'users' array with 1 user init

{
 groupname: "Admins",
 users: [
    { 
        email: [email protected], 
        first_name: 'bob'
    }
 ]
}

then I have to select the first element in the array,

users[0]

there is no problem with it, but then i just have to write more code in my application, the better way should be

user (-s)

so I can query

user.first_name

if someone knows a way let me know

Sumeet Kumar Yadav · Accepted Answer · 2014-08-13 18:49:40Z

1

You can use findOne as it returns a single document, where find returns a cursor.

>user =  db.groups.findOne({'users.email' : [email protected]}, {'users.$' => 1})
>user.first_name

answered Aug 13, 2014 at 18:49

Sumeet Kumar Yadav

13.2k6 gold badges53 silver badges88 bronze badges

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

Comments

Daniele Tassone · Accepted Answer · 2016-10-16 16:42:49Z

0

Depending from the driver you are using findOne is deprecated, you should use find().limit(1).next(function(err, doc){})

http://mongodb.github.io/node-mongodb-native/2.0/api/Collection.html#findOne

answered Oct 16, 2016 at 16:42

Daniele Tassone

2,1942 gold badges18 silver badges26 bronze badges

Collectives™ on Stack Overflow

mongodb find single embedded document as an object not as an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related