Timestramps in nested objects

Working with Data
,
1

I have collection like this,
{
“_id”:“65141e29d2f4fcd9c160deet”,
“CREATED_BY":"rajalakshmi.ramatchandirane@emerson.com”,
“CONTACTS”:“”,
“NOTES”:[
{
“DESCRIPTION”:“testing11”,
“TYPE”:“IN”,
“_id”:“65141e29d2f4fcd9c160d604”,
“updatedAt”:
“2023-09-27T12:21:05.198+00:00”,
“createdAt”:“2023-09-27T12:21:05.198+00:00”
}]
}

whenever I try to update the notes with _id createdAt and updatedAt is also getting updated.
I use the below query to do that operation,

db.mycollection.findOneAndUpdate({“_id”:“”, “NOTES._id”: NOTES[i]._id }, { $set: {“srType.$.NOTES”:obj} }, {new: true })

2

I would be very surprised if that would be the case. Your sample document DOES NOT have a field named SR_NOTES. So you either redacted the query or the sample document. In this case, we really cannot help you because we have no way to know what part of the information you share is correct and which one is wrongly redacted.

Please read Formatting code and log snippets in posts so that you documents and code can be used without further editing.

3

I have updated the code

4

Thanks but it is still unusable without editing because it is still not formatted according to the link I provided.

5 
{
"_id":"65142cdf3978eb7d80bc965a",
"ST_PARTY_SITE_ID": 739731,
    "ACTION": "submit",
    "NOTES": [
        {
            "TYPE": "INVOICE",
            "DESCRIPTION": "test 55454",
           
            "_id": "65143e3101b2a56e7e45022f",
          
            "updatedAt":"2023-09-27T15:21:03.815Z",
            "createdAt":"2023-09-27T15:21:03.815Z"
        }
    ]
}

db.mycollection.findOneAndUpdate({“_id”:“”, “NOTES._id”: NOTES[i]._id }, { $set: {“srType.$.NOTES”:obj} }, {new: true })

when I try to update the main collection, embedded documents behaves like it is getting inserted createdAt is always be same as updatedAt. but for me, createdAt should not get chnaged when we update the embedded document

6

When you write

what you actually asking is to replace the given array element with the object obj. So what ever fields and values the object obj has will end up stored in the document. You may use the dot notation to set the individuals fields you what. If $mergeObjects can be used in this context (something worth testing) then it would be less cumbersome than the dot notation.