MongoDB中如何实现集合嵌套数组字段存在指定userid时跳过，不存在则添加元素？

Got it, let's work through this problem step by step. You want to add a user to the users.assigned array only if their userid isn't already present, using findByIdAndUpdate. Here's how to make that happen:

Core Approach #

We need to combine two critical parts in the operation:

• A query filter that confirms the target userid doesn't exist in the users.assigned array yet.
• An update operation that pushes the new user object into the array when the filter matches.

Working findByIdAndUpdate Statement #

Here's the exact code you can use:

db.tasks.findByIdAndUpdate(
  {
    "_id": ObjectId("60ddd690c6d9014f7a8c9af2"),
    "users.assigned.userid": { $ne: ObjectId("5de8ad4263d21b900e1be386") }
  },
  {
    $push: {
      "users.assigned": {
        "userid": ObjectId("5de8ad4263d21b900e1be386"),
        "team": "APPLICATIONS DEVELOPMENT"
      }
    }
  },
  { new: true } // Optional: Returns the updated document instead of the original
)

Breakdown of Each Component #

• Query Filter:

  • _id targets the specific task document (since _id is unique, this alone is usually enough to locate the document).
  • users.assigned.userid: { $ne: ... } uses the $ne (not equal) operator to ensure no element in the users.assigned array has a matching userid—this prevents duplicate additions.

• Update Operation:

  • $push is MongoDB's operator for appending elements to an array. We target the users.assigned path and pass the new user object to add.

• Options:

  • new: true is optional but handy if you want the method to return the updated document (instead of the original state before the update).

Why This Works #

If the user's userid is already in the array, the query filter won't match any documents—so no update runs. If the userid is missing, the filter matches, and the $push adds the new user exactly as you want.

You don't need to include extra fields like createdDate or modifiedDate in your query unless you have a specific reason (like verifying the document hasn't changed since you last fetched it). Using _id plus the duplicate check is clean and efficient.

内容的提问来源于stack exchange，提问作者Shaleesh Madhavan