Can I query an array of subdocuments by multiple parameters with mongoose?

Question

I'm trying to find a user by their social services using service type and account id, but I don't know how to do this as a Mongoose query.

For example, how would I find this user, using Mongoose, if I have 'twitter' and '789DEF'?

{
"email":"[email protected]",
"social": [
        {
            "service": "linkedin",
            "username": "Test User",
            "url": "https://www.linkedin.com/in/testuser",
            "accountId": "ABC12356"
        },
        {
            "service": "twitter",
            "username": "TestUser",
            "url": "https://www.twitter.com/testuser",
            "accountId": "789DEF"
        }
    ]
}

Jorge Aranda · Accepted Answer · 2014-10-08 04:46:22Z

3

You need the $elemMatch query operator. Assuming you have declared a mongoose model (let's say Users), then something like this should work:

Users.findOne({
    social: {
        $elemMatch: {
            service: 'twitter',
            accountId: '789DEF'
        }
    }
}, function (err, doc) {
    // doc contains your user document
});

If what you need is only the relevant social subdocument, then you should also use the $ projection operator:

Users.findOne({
    social: {
        $elemMatch: {
            service: 'twitter',
            accountId: '789DEF'
        }
    }
}).select('social.$').exec(function (err, doc) {
    // ...
});

answered Oct 8, 2014 at 4:46

Jorge Aranda

2,1002 gold badges21 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Can I query an array of subdocuments by multiple parameters with mongoose?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related