Mongodb - Query Array of Objects, but only return one property

Question

I don't think this is a duplicate, but please correct me if I'm wrong. Anyway, I would like to return only "apple" and the customer member role that matches the user's object email address. I am using $elemMatch, but that returns the whole customer object, I only want the "member" property, that's it.

{
    "_id" : ObjectId("54d24e5df2878d40192beabd"),
    "apple" : "yes",
    "orange" : "yes",
    "customers" : [ 
        {
            "name" : "Jay Smith",
            "email" : "[email protected]",
            "member" : "silver", 
        },
        {
            "name" : "Sarah Carter",
            "email" : "[email protected]",
            "member" : "gold",
        },
        {
            "name" : "Jack Whatever",
            "email" : "[email protected]",
            "member" : "gold",
        },
    ]
 }

Ideal result back would be:

{
    "_id" : ObjectId("54d24e5df2878d40192beabd"),
    "apple" : "yes",
    "member" : "gold"
}

or even this would suffice:

{
    "_id" : ObjectId("54d24e5df2878d40192beabd"),
    "apple" : "yes",
    "orange" : "yes",
    "customers" : [
         {"member" : "gold"}
    ]
}

This is currently what I have:

   ItemsModel.find({ _id: { $in: _.pluck(user.items, 'itemId') }, active: true},
       {apple: 1, customers: {$elemMatch: {email: user.email}} }, 
           function(error, items) {
               if (error) { return next(error); }

                req.payload = {};
                req.payload.items = items;
                next();
            });

Any help would be really appreciated. Is this even possible? Thanks!

Yuri Zarubin · Accepted Answer · 2015-02-04 21:48:44Z

4

ItemsModel.aggregate([
  { $unwind: '$customers' },
  { $match: { _id: { $in: _.pluck(user.items, 'itemId'), 'customers.email': user.email } },
  { $project : { _id:1 , apple:1, member:'$customers.member' }}
], function(err, res){
  // rest of your code here
})

Will give you

{
    "_id" : ObjectId("54d24e5df2878d40192beabd"),
    "apple" : "yes",
    "member" : "gold"
}

edited Feb 4, 2015 at 21:48

answered Feb 4, 2015 at 20:58

Yuri Zarubin

11.7k4 gold badges33 silver badges34 bronze badges

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

2 Comments

Justin Over a year ago

I'm getting it as customers: ["member": "gold"], not as "member": "gold", but I'll still mark this as the correct answer. Genius stuff. Thank you!

Yuri Zarubin Over a year ago

Oops, should be member:'$customers.member'. I've modified my answer

Collectives™ on Stack Overflow

Mongodb - Query Array of Objects, but only return one property

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related