Querying from [array of objects] with mongoose find

Question

I have two Mongo schemas defined as follows:

var userSchema = new mongoose.Schema({
    email: String,
    password: String, //hash created from password
    firstName: String,
    lastName: String,
    comment:{userComment:String,adminComment:String},
    postalAddress: String,
    city: String,
    state: String,
    country: String,
    institution: String,
    privilege: {type: String, enum:['normal','chair','admin']},
    status: {type:String, enum: ['granted','removed','pending']},
    myConference:[{type:Schema.Types.ObjectId,ref:'Conference'}],
    mySubmission:[{type:Schema.Types.ObjectId,ref:'Submission'}]
});

var conferenceSchema = new mongoose.Schema({
    conferenceTitle: {type:String},
    conferenceDescription: String,
    conferenceStartDate:{type:Date, default: Date.now},
    submissionEndDate:{type:Date},
    reviewEndDate:{type:Date},
    **conferenceMembers:[{type:Schema.Types.ObjectId,ref:'User'}]**,
    conferenceSubmissions:[{type:Schema.Types.ObjectId,ref:'Submission'}],
    createdBy:{type:Schema.Types.ObjectId,ref:'User'},
    //chairMembers:[{type:Schema.Types.ObjectId,ref:'User'}],
    department:String
});

Requirement: I want to fetch all the Conference objects which match a certain _id i.e. unique for each 'User' schema object. conferenceMembers is an array of 'User' objects

What I did:

It's a POST:

var userId=req.body.userId

**Conference.find({userId: {$in: [Conference.conferenceMembers]}},function(err,conf){**
if(err){
                return res.send(500, err);
            }
return res.send(200,conf);

But, the filter doesn't seem to work here, I tried with $elemMatch as well but no luck.

There is no userId field in your ConferenceSchema. Are you sure you have posted correct code? — Ravi Shankar Bharti
– Ravi Shankar Bharti, Commented Aug 26, 2016 at 16:11
you should use conferenceMembers not userId in your find criteria. See the answer below. — Ravi Shankar Bharti
– Ravi Shankar Bharti, Commented Aug 26, 2016 at 16:22
My bad, the userID here is supposed to be the '_id' field for the conferenceMemebers (which is an array of objects) and which I put in req body earliers so I'm just fetching it here. — Shanky
– Shanky, Commented Aug 27, 2016 at 9:14

Ravi Shankar Bharti · Accepted Answer · 2016-08-26 16:21:22Z

1

To fetch all the documents which has specific userId in conferenceMembers, you can do this:

Conference.find({conferenceMembers : userId}).exec(function(err,conf){...});

if you want to populate the users too you can use mongoose populate.

Conference.find({conferenceMembers : userId}).populate('conferenceMembers').exec(function(err,conf){...});

edited Aug 26, 2016 at 16:21

answered Aug 26, 2016 at 16:16

Ravi Shankar Bharti

9,2786 gold badges31 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Querying from [array of objects] with mongoose find

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