node.jsmongodbmongoosemongoose-populate

populate with mongoose pagination


i tried to fetch data using npm mongoose-paginate but populate is not working

here is my UsersSchema.js

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var usersSchema = new Schema({
    name : String,
    created_at : { type : Date, default : Date.now }
});

module.exports = mongoose.model('users',usersSchema);

here is post schema

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var mongoosePaginate = require('mongoose-paginate');

var postsSchema = new Schema({
    user : { type: Schema.Types.ObjectId, ref: 'users' },
    post : String,
    created_at : { type : Date, default : Date.now }
});
postsSchema.plugin(mongoosePaginate);
module.exports = mongoose.model('posts',postsSchema);

here is my query

var options = {
    sort:     { created_at: -1 },
    lean:     true,
    offset:   offset,
    populate : 'users',
    limit:    10
};
postsSchema.paginate({user:user},options,function(err,posts){
    if(err){
        console.log(err)
        return false;
    }
    console.log(posts)
});

user provide objectID not a users data. i.e

[{
   user : objectID(987654ff11aa),
   post : 'post'
}]  

Solution

  • A populate have following things

    Post.find({})
    .populate([
        // here array is for our memory. 
        // because may need to populate multiple things
        {
            path: 'user',
            select: 'name',
            model:'User',
            options: {
                sort:{ },
                skip: 5,
                limit : 10
            },
            match:{
                // filter result in case of multiple result in populate
                // may not useful in this case
            }
        }
    ])
    .exec((err, results)=>{
       console.log(err, results)
    })