List last N record from MongoDB collection

Question

I have below route in my app.js

// Home Route
app.get('/', function(req, res){
  Entry.find({}, function(err, entries){
    if(err){
      console.log(err);
    } else {
      res.render('index', {
        entries: entries
      });
    }
  });
});

This is displaying all entries in Entry collection. I would like to display only last 100 records from db. What is the best way to do it?

I am using with below pug layout.

extends layout
    block content
      h1 #{title}
      ul.list-group
        each entry, i in entries
          li.list-group-item
            a(href=entry.entryurl)= entry.title

taha · Accepted Answer · 2020-05-20 19:07:00Z

2

Entry.find({}).sort({ "_id" : -1 }).limit(100).exec(function(err, entries) {
    // Do something here
});

edited May 20, 2020 at 19:07

answered May 20, 2020 at 18:35

taha

7227 silver badges16 bronze badges

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

1 Comment

thatthing Over a year ago

This is not loading any data.

Sean · Accepted Answer · 2020-05-20 18:37:39Z

1

You could also use javascript to only send the last 100 items to the Pug layout:

// Home Route
app.get('/', function(req, res){
  Entry.find({}, function(err, entries){
    if(err){
      console.log(err);
    } else {
      let lastHundred = entries.slice(-100);
      res.render('index', {
        entries: lastHundred
      });
    }
  });
});

answered May 20, 2020 at 18:37

Sean

8,3885 gold badges30 silver badges55 bronze badges

2 Comments

Ilijanovic Over a year ago

thats bad. you still load unnecessary the whole collection just to slice the last 100

thatthing Over a year ago

Appearently this is the only working solution so far but is @Ifaruki mentioned i dont want to load whole data and slice it.

Collectives™ on Stack Overflow

List last N record from MongoDB collection

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related