CODEWITHSUNDEEP
javascriptnode.jsmongodbexpressmongoose
fernon
fernon

Reputation: 113

mongoose countDocuments multiple keys

I have setup a Node get request to return the count of the keys in my database. However atm it returns the count of one key. I'd like to know how to add more keys to count. So instead of only counting Medium, I'd also like to count Small and Large.

    registerRoute.route("/countDocuments").get(function (req, res) {
   Sweatersizes.countDocuments({ sweatersize: "Medium" }, function (err, result) {
    if (err) {
      res.send(err);
    } else {
      res.json(result);
    }
  });
});

Thanks!

Upvotes: 1

Views: 424

Answers (3)

fernon
fernon

Reputation: 113

Thanks the both of you! This is de code that eventually responded how I wanted it to:

registerRoute.route("/countDocuments").get(function (req, res) {
  Sweatersize.aggregate([
    {
      $group: {
        count: { $sum: 1 },
        sweatersize: { $first: "$sweatersize" },
      },
    },
  ])
    .then((result) => {
      res.json(result);
    })
    .catch((error) => {
      console.log(error);
    });
});

Upvotes: 0

NeNaD
NeNaD

Reputation: 20354

You can do it with Aggregation framework and group pipeline:

registerRoute.route("/countDocuments").get(function (req, res) {
   Sweatersizes.aggregate([
     {
       "$group": {
         "_id": "$sweatersize",
         "total_count": {
           "$count": {}
         }
       }
     }
    ], function (err, result) {
      if (err) {
        res.send(err);
      } else {
        res.json(result);
      }
   });
});

Working example

Upvotes: 1

Takis
Takis

Reputation: 8705

Query

  • you can use group, and sum them seperatly

Test code here

aggregate(
[{"$group": 
   {"_id": "$sweatersize",
    "count": {"$sum": 1},
    "sweatersize": {"$first": "$sweatersize"}}},
 {"$unset": ["_id"]}])

Upvotes: 3

Related Questions