Query an array after populating with mongoose.js

Question

I'm trying to query an array of references after populating with their corresponding objects. I have a feeling I'm either not using the correct operational $... or my approach isnt the right way to go about what I need to do.

Ill give an example to clarify exactly what I'm trying to do. Say I have a collection of Users, who can have multiple Booking documents associated with them. I need find all Users who live in a certain location AND have at least one Booking whose start date is before today.

The models are along the lines of:

var Booking = new mongoose.Schema({
    starts_at: { type: Date },
    ends_at:   { type: Date },
    //...
});

var User = new mongoose.Schema({
    name: String,
    location: String,
    bookings: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Booking' }],
    //...
});

And the code/query I'm trying is along the lines of:

User.find({ 'location': 'some place' })
    .populate('bookings')
    .where({ 'bookings.starts_at': { $lte: new Date() } })
    .exec(function(err, users) {
        //...
    });

Any help or insights would be great

very similar, but the method there would give me with an array of matching Bookings, where as I need the Users as the result to work with — Scott
– Scott, Commented Dec 1, 2015 at 5:35
also, Bookings contains no back-reference - the reference is part of the same model that the inital/first query is performed on (User) so that method unfortunately doesnt work :( — Scott
– Scott, Commented Dec 1, 2015 at 5:47

Soni Pandey · Accepted Answer · 2015-11-30 07:03:37Z

1

 User
     .find({ 'location': 'some place'})
     .populate('bookings', null, 'starts_at' : { $lte: new Date()})
     .exec(function(err, result) {
        if (!err) {

            console.log(result);
        } else {
           console.log(err)
        }
 });

Please try with this!!

answered Nov 30, 2015 at 7:03

Soni Pandey

5145 silver badges16 bronze badges

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

3 Comments

Scott Over a year ago

thanks, this works as desired after adding the missing brackets around the last arg

JohnnyHK Over a year ago

@Scott This will not exclude users that don't have at least one booking before today.

Scott Over a year ago

thanks @JohnnyHK , yea I filter those out with a users = users.filter(function(user){ return user.bookings.length; }) - unless you can suggest a method I can include in the DB query?

Collectives™ on Stack Overflow

Query an array after populating with mongoose.js

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related