node.js - findOne Subdocument in Mongoose

Question

I am attempting a findOne query in Mongoose on a subdocument but I'm not having much luck...

My Schema looks like this:

var Team = mongoose.Schema({
    teamName:       String,
    teamURL:        String,
    teamMembers:    [{username: String, password: String, email: String, dateCreated: Date}],
});

var Team = db.model('Team', Team);

I need to simply find the users email from the document in which I am using this query

Team.findOne({'teamMembers.username': 'Bioshox'}, {'teamMembers.$': 1}, function (err, team) {
    if (team) {
        console.log(team[1].email);
    }
});

Any help would be appreciated!

Answer 1

You're missing the teamMembers level of your object, so your code needs to change to something like this:

Team.findOne({'teamMembers.username': 'Bioshox'}, {'teamMembers.$': 1},
    function (err, team) {
        if (team) {
            console.log(team.teamMembers[0].email);
        }
    }
);