1 回答

TA貢獻1804條經驗 獲得超3個贊
var tc = [
{"name":"Electronics & Hardware", "new_name" : "Electronics and Hardware"},
{"name":"Furniture & Fittings", "new_name" : "Furniture and Fittings"},
{"name":"Gems & Jewellery", "new_name" : "Gems and Jewellery"},
{"name":"Instrumentation", "new_name" : "IASC"},
{"name":"Iron & Steel", "new_name" : "Iron and Steel"},
]
tc.forEach(x => {
db.trainer_copy.updateMany({"jobRoles.sector.name":x["name"]},
{
$set: {
"jobRoles.$[jobRole].sector.name": x["new_name"]
}
},
{ arrayFilters: [{ "jobRole.sector.name": x["name"] }] }
)
})
在上面的答案中,名稱 jobRole 是數組中與過濾器匹配的索引的占位符 { "jobRole.sector.name" : x ["name"] }。
x ["name"] 是舊名稱并將其更新為新名稱即 x["new_name"]。
添加回答
舉報