mongodb - 如何在 MongoDB 中将来自其他集合的文档的整个值更新为来自另一个具有相同 ID 键的文档？

Question

我是非常新的 MongoDB。我想将来自其他集合的文档的整个值更新为来自另一个具有相同 ID 键的文档。谢谢您的帮助。

User Collection {  "_id": "19UUA66216A910058"
    "CIF": "19UUA66216A910058",
    "Fname": "Lily",
    "District": "AL",
    "CardNumber": "560222750987331000",
    "GroupID": "G04"
  },
  {
    "_id": "1C3CDWBA6CD988848",
    "CIF": "1C3CDWBA6CD988848",
    "Fname": "Wyn",
    "Lname": "Wisker",
    "Mobile": "7927567426",
  },

    Competition Collection {
    "_id": {
      "UserID": "1C3CDWBA6CD988848",
      "CompetitionID": 1
    },
    "UserID": "1C3CDWBA6CD988848",
    "CompetitionID": 1,
    "Join_date": {
      "$date": "2021-09-06T00:00:53Z"
    }
  },
  {
    "_id": {
      "UserID": "19UUA66216A910058",
      "CompetitionID": 4
    },
    "UserID": "19UUA66216A910058",
    "CompetitionID": 4,
    "Join_date": {
      "$date": "2021-09-13T06:00:03Z"
    }
  }

我的期望是更新集合中具有相同 CIFCompetition的所有文档的集合信息User

{  "_id": "19UUA66216A910058"
    "CIF": "19UUA66216A910058",
    "Fname": "Lily",
    "District": "AL",
    "CardNumber": "560222750987331000",
    "GroupID": "G04",
    "Competition: {"CompetitionID": 4,
"Join_date": {
  "$date": "2021-09-13T06:00:03Z"
}}

谢谢您的支持

标签： mongodb