How to query for objects stored in an array in a mongoDB

Question

I have the following nested object stored in my mongoDB:

var Appointment = new Schema ({

    students: [{user1:String,user2:String, _id: false}],
});

I now want to query my appointments for a studentName which is stored in the array students either in user1 or user2. But I have no idea how I could achieve that? If it is an array I would use:

    Appointment.find({
        students: {$in: [studentName]}
    }, function(err, appointmentsDb) {
        // do something
    });

JohnnyHK · Accepted Answer · 2013-08-26 13:06:58Z

2

You can use an $or operator and dot notation for this:

Appointment.find({ $or: [
    { 'students.user1': studentName },
    { 'students.user2': studentName }
]}, callback);

answered Aug 26, 2013 at 13:06

JohnnyHK

313k70 gold badges631 silver badges477 bronze badges

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

Collectives™ on Stack Overflow

How to query for objects stored in an array in a mongoDB

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related