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!
Query
aggregate(
[{"$group":
{"_id": "$sweatersize",
"count": {"$sum": 1},
"sweatersize": {"$first": "$sweatersize"}}},
{"$unset": ["_id"]}])
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);
}
});
});
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);
});
});