How to query nested objects with multiple value in MongoDB?

Question

I have array of nested objects in my MongoDB schema. Lets say,

var Post = {
    "title": "Some title",
    "advertisers" : [
        {
            "category" : "Tech",
            "name" : "Henry",
            "city" : "New york",
            "updated_at" : ISODate("2011-07-26T21:02:19Z"),
            "created_at" : ISODate("2011-07-26T21:02:19Z")
        },
    ]
}

I want to find the post based on the multiple values in nested schema. eg

Post.find({ 'advertisers.category' : 'Tech', 'advertisers.city': 'New York' });

It returns post which matches one of the above criteria. But i want posts which matches both.

How can i do it?

JohnnyHK · Accepted Answer · 2013-09-12 16:54:16Z

2

You can use the $elemMatch operator to do this:

Post.find({ advertisers: {$elemMatch: {category: 'Tech', city: 'New York' }}})

answered Sep 12, 2013 at 16:54

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

How to query nested objects with multiple value in MongoDB?

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