how to query nested arrays in mongoose

Question

I have a schema like this

'use strict';

var mongoose = require('mongoose');
var Schema = mongoose.Schema;

var TeacherSchema = new Schema({
    education: [{degree: String, instituteName: String}],
    dob: Date,
    photoUrl: String,
    phoneNumber: String,
    institutes: [{type: mongoose.Schema.ObjectId, ref: 'Institute'}],
    subjects: [{
        name: String,
        topics: [{
            name: String,
            modules: [{
                name: String,
                classes: [{
                    name: String,
                    startTime: Date,
                    endTime: Date,
                    fee: Number
                }]
            }]
        }]
    }],
    created: {type: Date, default: Date.now}
})

module.exports = mongoose.model('Teacher', TeacherSchema);

My question is how can i query in the nested arrays? To be specific Lets say i want to find all the teachers who have at least one subject/topic/module/class whose name starts with "Math". How can i do that with mongoose?

Community · Accepted Answer · 2017-05-23 12:14:15Z

16

See if this works...

db.Teacher.find({$or:
[{'subjects':{"$elemMatch":{'name':'Math'}}},
{'subjects.topics':{"$elemMatch":{'name':'Math'}}},
{'subjects.topics.modules.classes':{"$elemMatch":{'name':'Math'}}}]
})

However, I am curious to know why a modules array is needed when all it contains is a classes array?

Let's say you want to search with wildcard "ath"

db.stack30173606.find({$or: [
{'subjects':{"$elemMatch":{'name':'Math'}}}, 
{'subjects.topics':{"$elemMatch":{'name':'math'}}}, 
{'subjects.topics.modules':{"$elemMatch":{'name':'Math'}}}, 
{'subjects.topics.modules.classes.name':{"$in":[/math/]}}
] })

For case insensitive, check this: How do I make case-insensitive queries on Mongodb?

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered May 11, 2015 at 18:42

Nagasimha Iyengar

4615 silver badges8 bronze badges

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

2 Comments

Raghvendra Singh Over a year ago

Thanks. This works but only if the name is equal to what i give. How can i do this for like and case insensitive ??

Raghvendra Singh Over a year ago

i tried that it doesn't work Here is my subject inside teacher "subjects" : [ { "name" : "Mathematics", "topics" : [ { "name" : "math topic", "modules" : [ { "name" : "math module","classes" : [ { "name" : "math class" } ] } ] } ] } ] I have removed some stuff to fit in the comment. Here is my query db.teachers.find({$or: [{'subjects':{"$elemMatch":{'name':'Math'}}}, {'subjects.topics':{"$elemMatch":{'name':'math'}}}, {'subjects.topics.modules':{"$elemMatch":{'name':'Math'}}}, {'subjects.topics.modules.classes':{"$in":[/math/]}}] }); It returns me nothing.

Collectives™ on Stack Overflow

how to query nested arrays in mongoose

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