MongoDB conditional aggregation with unwind

Question

I have db collection like:

{
  "_id" : "af5c00e4-d3a8-419d-8793-c0cf328802ec",
    "collaborators" : [
        {
            "_id" : "9bd2eee8-bf6c-4c6f-bab7-d2d175aed807",
            "origin" : [
                {
                    "originId" : "123"
                }
            ],
            "firstName" : "Parveen",
            "lastName" : "Vendor",
            "email" : "[email protected]"
        },
        {
            "_id" : "234324-bf6c-4c6f-bab7-d2d175aed807",
            "origin" : [
                {
                    "originId" : "1234"
                }
            ],
            "firstName" : "Parveen123",
            "lastName" : "34",
            "email" : "[email protected]"
        }
    ],
    "orders" : [
        {
            "totalAmount" : 10,
            "collaborators" : [
                {
                    "origin" : [
                        {
                            "originId" : "123",
                        }
                    ],
                    "type" : "Supplier"
                },
                {
                    "origin" : [
                        {
                            "originId" : "1233",
                        }
                    ],
                    "type" : "Supplier"
                }
            ]
        }
    ]
}

Want to replace data in orders (array) collaborators(array) with

**collaborators(array) ** data if matches originId of both

Expected output

{
  "_id" : "af5c00e4-d3a8-419d-8793-c0cf328802ec",
    "collaborators" : [
        {
            "_id" : "9bd2eee8-bf6c-4c6f-bab7-d2d175aed807",
            "origin" : [
                {
                    "originId" : "123"
                }
            ],
            "firstName" : "Parveen",
            "lastName" : "Vendor",
            "email" : "[email protected]"
        },
        {
            "_id" : "234324-bf6c-4c6f-bab7-d2d175aed807",
            "origin" : [
                {
                    "originId" : "1234"
                }
            ],
            "firstName" : "Parveen123",
            "lastName" : "34",
            "email" : "[email protected]"
        }
    ],
    "orders" : [
        {
            "totalAmount" : 10,
            "collaborators" : [
                {
                    "_id" : "9bd2eee8-bf6c-4c6f-bab7-d2d175aed807",
                    "origin" : [
                        {
                            "originId" : "123"
                        }
                    ],
                    "firstName" : "Parveen",
                    "lastName" : "Vendor",
                    "email" : "[email protected]"
                },
                {
                    "origin" : [
                        {
                            "originId" : "1233",
                        }
                    ],
                    "type" : "Supplier"
                }
            ]
        }
    ]
}

One collection record can have multiple collaborators , same as order can have multiple collaborators. Need to replace only where originId matches

Why are collaborators.origin and orders.collaborators.origin are arrays? Will they always include only one item? — nimrod serok
– nimrod serok, Commented Jun 24, 2022 at 20:35
@nimrodserok yes, only one. But due to some third party dependency its in array — parveen
– parveen, Commented Jun 26, 2022 at 16:45

nimrod serok · Accepted Answer · 2022-06-26 20:09:19Z

One option is:

Use $map, $mergeObjects and $filter to add a new key to each item of orders.collaborators with the matching item from collaborators if exists.
choose the new key if it contains data or the original key, if not.

db.collection.aggregate([
  {$set: {
      ordersCollaborators: {
        $map: {
          input: {$first: "$orders.collaborators"},
          in: {$mergeObjects: [
              {original: "$$this"},
              {new: {
                  $filter: {
                    input: "$collaborators",
                    as: "i",
                    cond: {
                      $eq: [
                        {$first: "$$i.origin.originId"},
                        {$first: "$$this.origin.originId"}
                      ]
                    }
                  }
                }
              }
            ]
          }
        }
      }
    }
  },
  {$set: {
      orders: [
        {totalAmount: {$first: "$orders.totalAmount"},
          collaborators: {
            $map: {
              input: "$ordersCollaborators",
              in: {
                $cond: [
                  {$eq: [{$size: "$$this.new"}, 0]},
                  "$$this.original",
                  "$$this.new"
                ]
              }
            }
          }
        }
      ],
      ordersCollaborators: "$$REMOVE"
    }
  }
])

See how it works on the playground example

Collectives™ on Stack Overflow

MongoDB conditional aggregation with unwind

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related