IT討論區(169) - 小心搵工

唔係起樓但做過工程公司既p仔

驚驚，不過個head好老定話公司唔開六日
希望堅

ching會唔會落埋地盤到睇？

aecom?

update one 定 update many

抽個document改再save

你select個document出嚟之後 .timeslot.staff 再 obj.save()

why timeslot係list?

nested object 你改obj入面個obj要object freeze or JSON.parse(JSOn.stringify(obj))

試下

交俾你

lm學嘢

https://mongoplayground.net/p/Td1QwxiMCJ2

db.collection.update({},
[
  {
    "$addFields": {
      "timeslot": {
        "$map": {
          "input": "$timeslot",
          "as": "ts",
          "in": {
            "$cond": {
              // criteria for element you want to update
              "if": {
                $eq: [
                  "$$ts.time",
                  "00:00"
                ]
              },
              "then": {
                "$mergeObjects": [
                  "$$ts",
                  // to-be version of staff
                  {
                    staff: [
                      "A",
                      "B"
                    ]
                  }
                ]
              },
              "else": "$$ts"
            }
          }
        }
      }
    }
  }
],
{
  multi: false
})

你個schema好複雜... 要用$map 去process個timeslot array再用$cond做conditional update... api syntax嗰d唔多講了, 自己查返doc, 有d問題想問:
1. 點解date store as string?唔store as proper date object?
2. 點解timeslot 唔flatten咗佢, 成個collection一個document就一個timeslot嘅array entry?

成個array scan
暫時唔清楚層主係咪要喺array搵element update
可能攰睇漏requirement

大大伏