Skip to content

Instantly share code, notes, and snippets.

@rtt
Created September 9, 2013 10:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rtt/6494086 to your computer and use it in GitHub Desktop.
Save rtt/6494086 to your computer and use it in GitHub Desktop.
> db.foo.aggregate([{$unwind: '$sub'}, {$match: {start: {$lte: 3}, end: {$gte: 6} }}])
{
"result" : [
{
"_id" : ObjectId("522da57d186b82d5279cb35c"),
"start" : 3,
"end" : 6,
"sub" : {
"start" : 3,
"end" : 6
}
},
{
"_id" : ObjectId("522da57d186b82d5279cb35c"),
"start" : 3,
"end" : 6,
"sub" : {
"start" : 6,
"end" : 7
}
}
],
"ok" : 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment