Breaking News: Grepper is joining You.com. Read the official announcement!

Using multiple $lookup with aggregation in mongodb

Vishnu answered on July 31, 2022 Popularity 8/10 Helpfulness 3/10

answer Using multiple $lookup with aggregation in mongodb

related mongodb aggregate lookup multiple fields

Using multiple $lookup with aggregation in mongodb

Comment

db.getCollection('_project').aggregate([
     {$lookup:{from: "_build",localField: "_id",foreignField: "ProjectId",as:"result"}},
     {$unwind:"$result"},
     {$project:{_id:0,ProjectId:"$_id",BuildId:"$result._id"}},
     {$lookup:{from:"_build.detail",localField:"BuildId",foreignField:"BuildId",as:"resultS2"}},
     {$unwind:"$resultS2"},
     {$group:{
    _id:{ProjectId:"$ProjectId", BuildId:"$BuildId",campaignName:"$resultS2.Data.Campaign Name",adSet:"$resultS2.Data.Ad Set Name"},
    uniqueAdNames:{$addToSet:"$resultS2.Data.Ad Name"}
        }
     },
     {$addFields:{uniqueAdsCount:{$size:"$uniqueAdNames" }}},
     {$group :{
     _id:{ProjectId:"$_id.ProjectId",BuildId:"$_id.BuildId",campaignName:"$_id.campaignName"},
     uniqueAdNames:{$first:"$uniqueAdNames"},
     uniqueAdsCount:{$first:"$uniqueAdsCount"},
     uniqueAdSets:{$addToSet:"$_id.adSet"}
        }
     },
     {$addFields:{uniqueAdsetCount:{$size:"$uniqueAdSets"}}},
     {$group:{
     _id:{ProjectId:"$_id.ProjectId",BuildId:"$_id.BuildId"},
     uniqueAdNames:{$first:"$uniqueAdNames"},
     uniqueAdsCount:{$first:"$uniqueAdsCount"},
     uniqueAdSetNames:{$first:"$uniqueAdSets"},
     uniqueAdsetCount:{$first:"$uniqueAdsetCount"},
     uniqueCampaignNames:{$addToSet:"$_id.campaignName"}
        }
     },
     {$addFields:{uniqueCampaignCount:{$size : "$uniqueCampaignNames"}}}
  ])

Popularity 8/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: aggregation mongodb using whatever

Link to this answer
Share Copy Link

Contributed on Jul 31 2022

Vishnu

0 Answers Avg Quality 2/10

Closely Related Answers

mongodb aggregate lookup multiple fields

Comment

Multiple lookup with same collection MongoDb Aggregate

db.collection2.aggregate([
       {
          $lookup: {
             from: "collection1",
             let: {
                firstUser: "$user1",
                secondUser: "$user2"
             },
             pipeline: [
                {
                   $match: {
                      $expr: {
                         $and: [
                            {
                               $eq: [
                                  "$user1",
                                  "$$firstUser"
                               ]
                            },
                            {
                               $eq: [
                                  "$user2",
                                  "$$secondUser"
                               ]
                            }
                         ]
                      }
                   }
                }
             ],
             as: "result"
          }
       },
       {
          $replaceRoot: {
             newRoot: {
                $mergeObjects:[
                   {
                      $arrayElemAt: [
                         "$result",
                         0
                      ]
                   },
                   {
                      percent1: "$$ROOT.percent1"
                   }
                ]
             }
          }
       }
    ]
)

Popularity 7/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: mongodb whatever lookup aggregate look

Link to this answer
Share Copy Link

Contributed on Feb 15 2023

Jaimin Patel

0 Answers Avg Quality 2/10

Using multiple $lookup with aggregation in mongodb

Contents

More Related Answers

Using multiple $lookup with aggregation in mongodb

Closely Related Answers

mongodb aggregate lookup multiple fields

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.