Skip to content

Instantly share code, notes, and snippets.

@robozavri
Last active September 10, 2020 08:08
Show Gist options
  • Save robozavri/d0dffa3242646e44662eadc303dd927a to your computer and use it in GitHub Desktop.
Save robozavri/d0dffa3242646e44662eadc303dd927a to your computer and use it in GitHub Desktop.
#mongodb sort by date
return Model.aggregate([
{ $lookup: {from: 'courses', localField: 'courseId', foreignField: '_id', as: 'course'} },
{ $sort: { date: 1 } },
{$group : { _id: {
year : { $year: '$date' },
month : { $month: '$date'},
day : { $dayOfMonth: '$date'},
// date: '$date'
},
'count' : { $sum: 1 },
sessions: {$push: '$$ROOT'}
}},
{ '$unwind': '$_id' },
{ $sort: { '_id.month': 1, '_id.day': 1} },
]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment