Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.products.aggregate([
- {$match : {"items.id": ObjectId("5880b8c1e9f131060a4a4aa6"), "type": "Test Pack"}},
- {$unwind : "$items"},
- {
- $lookup : {
- from : "products",
- localField: "_id",
- foreignField: "items.id",
- as : "test_series"
- }
- },
- {$unwind: "$test_series"},
- {$group : {
- _id : "$test_series._id",
- "title": {$first: "$test_series.title"},
- "series_items": {$first: "$test_series.items"},
- "pack_items": {$push: "$items"},
- "releaseDate": {$first: "$test_series.releaseDate"},
- "availTill" : {$first: "$test_series.availTill"},
- "stage" : {$first: "$test_series.stage"},
- "stage" : {$first: "$test_series.stage"},
- "isHidden" : {$first: "$test_series.isHidden"}
- }
- }
- ])
Advertisement
Add Comment
Please, Sign In to add comment