NodeJS + MongoDB - Want to add more nested values

Question

I have the following JSON structure:

 JSON =  { "change_number": "CRQ91320s23",
         "change_description": "Nexusg work",
         "date": "2/10/2020",
         "changeowner" : "Jeffre Hocking",
         "implementer" : "john Elazi",
         "PVT_testers": {
           "Epic": {
             "contact": "nathanbdas",
             "email": "[email protected]" }}

I am using mongoDB + NodeJS to interface with it..

I want to add another entry beside "Epic" under "PVT_testers"..

This is my code, and when I run it, it replaces Epic with EPIC2 rather than adding to the same level.

Have cleaned the code to make it easier.

MongoClient.connect(url, function(err, db) {
  var dbo = db.db("radar");
  var myquery = {  "change_number" : req.params.id };
  var newvalues = { $set: {"PVT_testers"  : {"EPIC2" : {"das2": "asd", "das2": "asd", "results": { "pre_outcome":"sucess" }}}     }}
   dbo.collection("changes").updateOne(myquery, newvalues, function(err, res) {
      if (err) return res.json("Error:Database error" ); 
    console.log(res)
    db.close();
});

P.E. Joëssel · Accepted Answer · 2020-10-24 12:39:14Z

2

When using $set operator, you are updating the whole object (sub-document in mongodb linguo). To add a new field, use the dot notation:

var newvalues = {
  $set: {
    "PVT_testers.EPIC2": {
      "das2": "asd", 
      "das2": "asd", 
      "results": { 
        "pre_outcome": "sucess" 
      }
    }
  }
}

answered Oct 24, 2020 at 12:39

P.E. Joëssel

1,45311 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nathanaelx Over a year ago

Thanks that helps a bit.. But the new addition is what looks like a list?

P.E. Joëssel Over a year ago

you mean like an array ?

Collectives™ on Stack Overflow

NodeJS + MongoDB - Want to add more nested values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related