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

mongodb lookup multiple fields

Add Answer

Cautious Caracal answered on July 1, 2020 Popularity 9/10 Helpfulness 3/10

answer mongodb lookup multiple fields

related mongodb match multiple fields

related mongodb aggregate lookup multiple fields

related mongodb find multiple fields

mongodb lookup multiple fields

Comment

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 9/10 Helpfulness 3/10 Language javascript

Source: stackoverflow.com

Tags: javascript mongodb-lookup

Link to this answer
Share Copy Link

Contributed on Mar 09 2021

Cautious Caracal

0 Answers Avg Quality 2/10

Closely Related Answers

mongodb match multiple fields

Comment

$match:
{
	$and: [
    {'ExtraFields.value': {$in: ["A52A2A"]}}, 
    {'ExtraFields.fieldID': ObjectId("5535627631efa0843554b0ea")}
    ]
}

Popularity 10/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: match matc

Link to this answer
Share Copy Link

Contributed on Jul 01 2020

Defiant Dogfish

0 Answers Avg Quality 2/10

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: aggregate lookup mongodb mongod

Link to this answer
Share Copy Link

Contributed on Feb 15 2023

Jaimin Patel

0 Answers Avg Quality 2/10

mongodb find multiple fields

Comment

-1

{ <field1>: <value>, <field2>: <value> ... }

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: docs.mongodb.com

Tags: find

Link to this answer
Share Copy Link

Contributed on Dec 06 2020

Worrisome Wallaby

0 Answers Avg Quality 2/10

mongodb lookup multiple fields

Contents

More Related Answers

mongodb lookup multiple fields

Closely Related Answers

mongodb match multiple fields

mongodb aggregate lookup multiple fields

mongodb find multiple fields

Grepper

Documentation

Social

Legal

Contact

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