How do I get a variable out of a mongodb query in node js?

Question

I want to get a variable out of a mongodb query in node.js which would count the number of documents in a collection named students

I tried to declare a global variable right before the query and tried to assign the value inside the query function:

router.get('/dashboard', loggedin, function (req, res, next) {
// Student is a db object of a collection named students
var std_count

Student.find(function(err, doc) {
  if(err) console.log(err)
  else {
  std_count = doc.length
  }
})

console.log(std_count)

res.render('dashboard', {
  user:req.user
  })
});

The console.log() always prints undefined, but if I put the console.log() inside else{} block, it prints the correct result.

I need to do 4 more queries like this (say teachers, courses etc.) and send them altogether in res.render()

Any help would be appreciated.

because student.find is asynchronous

Kunal Mukherjee
– Kunal Mukherjee

2019-05-09 06:17:34 +00:00
Commented May 9, 2019 at 6:17 — Kunal Mukherjee
– Kunal Mukherjee, Commented May 9, 2019 at 6:17
possible dup of stackoverflow.com/questions/14220321/…

arizafar
– arizafar

2019-05-09 06:25:05 +00:00
Commented May 9, 2019 at 6:25 — arizafar
– arizafar, Commented May 9, 2019 at 6:25

Kunal Mukherjee · Accepted Answer · 2019-05-09 07:02:47Z

1

Mongoose .find returns a promise by chaining .exec to the end,

router.get('/dashboard', loggedin, function (req, res, next) {

    // Student is a db object of a collection named students
    Student.find({})
    .exec()
    .then(data => {

        const std_count = data.length;
        res.render('dashboard', {
            user:req.user
        });
    })
    .catch(err => res.status(500));

});

Update:

Then you can use await each query and send them lastly in the res.render.

router.get('/dashboard', loggedin, async function (req, res, next) {
    try {
        const std_count = (await Student.find({}).exec()).length || 0;
        const teachers_count = (await Teachers.find({}).exec()).length || 0;
        const courses_count = (await Courses.find({}).exec()).length || 0;

        return res.render('dashboard', { 
            user: req.user,
            studentCount: std_count,
            teacherCount: teachers_count,
            coursesCount: courses_count
        });

    } catch (err) {
        return res.status(500);
    }
});

edited May 9, 2019 at 7:02

answered May 9, 2019 at 6:29

Kunal Mukherjee

5,8733 gold badges29 silver badges55 bronze badges

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

2 Comments

10ZKhaled Over a year ago

I know it would work, but i need to do 4 more queries like this say(teachers, coursers, etc) and send them altogether in res.render(). Hope you can understand the situation.

Kunal Mukherjee Over a year ago

@10ZKhaled Please update that into the question details

Collectives™ on Stack Overflow

How do I get a variable out of a mongodb query in node js?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related