Skip to content

Instantly share code, notes, and snippets.

@gabrielstuff
Created March 11, 2015 23:20
Show Gist options
  • Save gabrielstuff/13cea6ab0ad6c9dc34eb to your computer and use it in GitHub Desktop.
Save gabrielstuff/13cea6ab0ad6c9dc34eb to your computer and use it in GitHub Desktop.
CFS query
db['cfs.medias.filerecord'].aggregate(
[
{
$project:
{
year: { $year: "$uploadedAt" },
month: { $month: "$uploadedAt" },
day: { $dayOfMonth: "$uploadedAt" },
hour: { $hour: "$uploadedAt" },
minutes: { $minute: "$uploadedAt" },
seconds: { $second: "$uploadedAt" },
milliseconds: { $millisecond: "$uploadedAt" },
dayOfYear: { $dayOfYear: "$uploadedAt" },
dayOfWeek: { $dayOfWeek: "$uploadedAt" },
week: { $week: "$uploadedAt" }
}
},
{ "$group" :
{ "_id" : {
"year" : "$year",
"month" : "$month",
"day" : "$day"
},
"medias": {
"$push": "$ROOT"
}
}
}
]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment