Node js mongoose populate limit

Question

I have two schema say city and blogs. I want to create a blog page with pagination. So I am populating blogs with reference to city name. Say if I dont have a blog for a city then it should not be returned. Here is my query to get the blogs.

City.find().skip(req.params.pageIndex*2).limit(2).sort('-created').populate('articles').exec(function(err, cities) {

res.jsonp(cities)

}

If I use the above query. I get the cities with no blogs as well. So it results in an empty row in the view. I don't want that to happen. How to limit the populated field and not return the city without blogs. Any suggestions?

camilo posada · Accepted Answer · 2016-03-16 17:59:35Z

34

City.find({}).populate({
    path:'Articles',
    options: {
        limit: 2,
        sort: { created: -1},
        skip: req.params.pageIndex*2

    }
}).exec(function (err, cities) {
    if (err) return handleError(res, err);
    return res.status(200).json(cities);
});

answered Mar 16, 2016 at 17:59

camilo posada

3413 silver badges8 bronze badges

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

Comments

Praveen AK · Accepted Answer · 2021-11-01 08:25:30Z

4

Instead of using

{options:{limit:2}}

Use like

{perDocumentLimit:2}

Its works for me

answered Nov 1, 2021 at 8:25

Praveen AK

6418 silver badges10 bronze badges

Collectives™ on Stack Overflow

Node js mongoose populate limit

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related