$mergeObjects requires object inputs, but input is of type array

Question

I am trying to add one property if current user has permission or not based on email exists in array of objects.

My input data looks like below.

[
  {
    nId: 0,
    children0: [
      {
        nId: 3,
        access: [
          {
            permission: "view",
            email: "[email protected]"
          }
        ]
      },
      {
        nId: 4,
        access: [
          {
            permission: "view",
            email: "[email protected]"
          }
        ]
      }
    ]
  }
]

https://mongoplayground.net/p/xZmRGFharAb

[
  {
    "$addFields": {
      "children0": {
        "$map": {
          "input": "$children0.access",
          "as": "accessInfo",
          "in": {
            "$cond": [
              {
                "$eq": [
                  "$$accessInfo.email",
                  "[email protected]"
                ]
              },
              {
                "$mergeObjects": [
                  "$$accessInfo",
                  {
                    "hasAccess": true
                  }
                ]
              },
              {
                "$mergeObjects": [
                  "$$accessInfo",
                  {
                    "hasAccess": false
                  }
                ]
              },
              
            ]
          }
        }
      }
    }
  }
]

I also tried this answer as following, but that is also not merging the object.

https://mongoplayground.net/p/VNXcDnXl_sZ

Charchit Kapoor · Accepted Answer · 2022-08-30 15:30:31Z

1

Try this:

db.collection.aggregate([
  {
    "$addFields": {
      "children0": {
        "$map": {
          "input": "$children0",
          "as": "accessInfo",
          "in": {
            nId: "$$accessInfo.nId",
            access: "$$accessInfo.access",
            hasAccess: {
              "$cond": {
                "if": {
                  "$ne": [
                    {
                      "$size": {
                        "$filter": {
                          "input": "$$accessInfo.access",
                          "as": "item",
                          "cond": {
                            "$eq": [
                              "$$item.email",
                              "[email protected]"
                            ]
                          }
                        }
                      }
                    },
                    0
                  ]
                },
                "then": true,
                "else": false
              }
            }
          }
        }
      }
    }
  }
])

Here, we use one $map to loop over children0 and then we filter the access array to contain only elements with matching emails. If the filtered array is non-empty, we set hasAccess to true.

Playground link.

edited Aug 30, 2022 at 15:30

answered Aug 30, 2022 at 15:11

Charchit Kapoor

9,3242 gold badges11 silver badges26 bronze badges

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

3 Comments

Anonymous Creator Over a year ago

that gives hasAccess inside access array, we need that in parallel to 'access' key. so if user exists in array then it will be like { nId: 3, hasAccess: true }

Anonymous Creator Over a year ago

Phew. Thanks a lot man. You are an angel. Spent entire day after this.

Charchit Kapoor Over a year ago

Cool. Take a chill pill now.

Collectives™ on Stack Overflow

$mergeObjects requires object inputs, but input is of type array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related