Add new field based on nested array object

Question

I have a collection with a nested object array, I want to add a new boolean field to the document if the nested object array contains an item or not.

I could solve this by using map and in operators in two seperate addFields aggregation, but I wonder whether there is cleaner and smarter solution.

Sample Document:

[
  {
    "_id": "630875a5d0d70edb88e19a7b",
    "favorites": [
      {
        "_id": "6309ef9e538eef79c9e53827",
        "user": "6304d72e213e817ee090eb93",
        "recipe": "630875a5d0d70edb88e19a7b"
      },
      {
        "_id": "630f1b5a8f00dfa9a7a5006c",
        "user": "63066ce10722fdb443efb1f6",
        "recipe": "630875a5d0d70edb88e19a7b"
      }
    ]
  }
]

The solution I have:

db.collection.aggregate([
  {
    $addFields: {
      favoritedUserIds: {
        $map: {
          input: "$favorites",
          as: "favorited",
          in: "$$favorited.user"
        }
      }
    }
  },
  {
    $addFields: {
      isFavorited: {
        $in: [
          "6304d72e213e817ee090eb93", // user id
          "$favoritedUserIds"
        ]
      }
    }
  },
  {
    "$unset": "favoritedUserIds"
  }
])

Mongo Playground

Yong Shun · Accepted Answer · 2022-09-01 12:33:04Z

2

You can just check whether the parameter is in favorites.user array.

db.collection.aggregate([
  {
    $addFields: {
      isFavorited: {
        $in: [
          "6304d72e213e817ee090eb93",
          "$favorites.user"
        ]
      }
    }
  }
])

Demo @ Mongo Playground

answered Sep 1, 2022 at 12:33

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Add new field based on nested array object

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