CODEWITHSUNDEEP
node.jsexpressmongoose
MMR
MMR

Reputation: 3009

How to get data and count in one query in mongoose

I tried to get notification as well as the data in one query and i tried like below but this is giving only count,

 Categories.find(item).count().exec(function (err, result) {}

Can anyone please suggest help.

Upvotes: 2

Views: 3183

Answers (2)

Yaki Klein
Yaki Klein

Reputation: 4366

You can use @abdulbarik method if you want to fetch all the records.

If you are using a limit on the amount of data you need and you want the full count you can do the following: 

Categories.count(query, function (err, count) {

        Categories.find(query)
            .limit(limit)
            .toArray(cb);
    });

Upvotes: -1

abdulbari
abdulbari

Reputation: 6232

You can't get your data like this way as @adeneo said in the comment.

Use find to get all records and then check length of records

Categories.find({query},function (err, result) {
  if(!err){
    if(Array.isArray(result))
       var count=result.length;
  }
});

Upvotes: 3

Related Questions