Skip to content

Instantly share code, notes, and snippets.

@mirsahib
Created December 16, 2019 07:35
Show Gist options
  • Save mirsahib/291ccea9f6db68e1e4f19ad7b81df4e4 to your computer and use it in GitHub Desktop.
Save mirsahib/291ccea9f6db68e1e4f19ad7b81df4e4 to your computer and use it in GitHub Desktop.
router.get("/semester", async (req, res) => {
var data = req.query;
console.log(data.str + " " + data.end);
var str = data.str;
var end = data.end;
var query = [
{
$match: {
Year: {
$gte: "$$str",
$lt: "$$end"
}
}
},
{
$group: {
_id: {
Year: "$Year",
Semester: "$Semester"
},
total: {
$sum: "$Students"
}
}
},
{
$sort: {
_id: -1
}
}
];
var cursor = await Record.aggregate(query);
console.log(cursor);
res.status(200).send({ message: "success" });
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment