mongodb joining two table with multiple array

Question

I have one table membership and another is promo codes.

membership table:

/* 1 */
{
    "_id" : ObjectId("5b62e7050b13587e9febb8db"),
    "country_id" : "5a093507f1d45633844096ef",
    "type" : "Bronze",
    "price" : "30",
}
/* 2 */
{
    "_id" : ObjectId("5b6961175140b477032291b7"),
    "country_id" : "5a093507f1d45633844096ef",
    "type" : "Gold",
    "price" : "1000",
}....

promo code table :

{
    "_id" : ObjectId("5cfe23fd075be65883f6d921"),
    "final_status" : 1,
    "membership" : [ 
        ObjectId("5b62e7050b13587e9febb8db"), 
        ObjectId("5b6961175140b477032291b7"), 
        ObjectId("5b6961285140b477032291b8"), 
        ObjectId("5b7567dd5b874856981b53d3"), 
        ObjectId("5bba1c3794c6761db256edbc")
    ],
    "month" : [ 
        "1", 
        "3"
    ]
}

here, the promomcode table has a membership id. I want promo code data with membership join query.get promo code data with membership detail Please help me

Possible duplicate of $lookup on ObjectId's in an array

Vikash_Singh
– Vikash_Singh

2019-06-11 08:43:33 +00:00
Commented Jun 11, 2019 at 8:43 — Vikash_Singh
– Vikash_Singh, Commented Jun 11, 2019 at 8:43

Vikash_Singh · Accepted Answer · 2019-06-11 08:45:13Z

1

Use $lookup for left outer join in mongodb

db.promocode.aggregate([{
  $lookup: {
    from: 'membership',
    localField: 'membership',
    foreignField: '_id',
    as: 'memberships'
  }
}, {
  $project: {
    membership: 0
  }
}])

answered Jun 11, 2019 at 8:45

Vikash_Singh

1,8962 gold badges16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mongodb joining two table with multiple array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related