nickzuck_007

Get test series from test id

Mar 18th, 2019
339
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 0.88 KB | None | 0 0
  1. db.products.aggregate([
  2.     {$match : {"items.id": ObjectId("5880b8c1e9f131060a4a4aa6"), "type": "Test Pack"}},
  3.     {$unwind : "$items"},
  4.     {
  5.         $lookup : {
  6.             from : "products",
  7.             localField: "_id",
  8.             foreignField: "items.id",
  9.             as : "test_series"
  10.         }
  11.     },
  12.     {$unwind: "$test_series"},
  13.     {$group : {
  14.             _id : "$test_series._id",
  15.             "title": {$first: "$test_series.title"},
  16.             "series_items": {$first: "$test_series.items"},
  17.             "pack_items": {$push: "$items"},
  18.             "releaseDate": {$first: "$test_series.releaseDate"},
  19.             "availTill" : {$first: "$test_series.availTill"},
  20.             "stage" : {$first: "$test_series.stage"},
  21.             "stage" : {$first: "$test_series.stage"},
  22.             "isHidden" : {$first: "$test_series.isHidden"}
  23.         }
  24.     }
  25. ])
Advertisement
Add Comment
Please, Sign In to add comment