Add new field to a specific object in mongoDB

Question

I want to add a new field to a an object after i search the specific object, Database looks like this:

{
    "_id": {
        "$oid": "608378ef1ae6b1368c6220c6"
    },
    "username": "paul",
    "password": "cacavaca123",
    "question": "q1",
    "answer": "cutu"
}
{
    "_id": {
        "$oid": "6084c1b557f2242bcc629440"
    },
    "username": "mircea",
    "password": "123456",
    "question": "q1",
    "answer": "cutu"
}

And i want to search in db for the object with username: paul and add a new field friends:[alex], I have tried this but its not working:

MongoClient.connect(uri, function(err, db) {
        var dbc = db.db("chat");
        dbc.collection("accounts").find({username: { $eq: user}}).aggregate( [
            {
              $addFields: {
                frequent:[new_friend]
              }
            }
        ])

        db.close();
    });

Also if you know, can you tell me how to update that array of friends and add a new friend to that array?

Tushar Gupta - curioustushar · Accepted Answer · 2021-04-29 03:41:07Z

2

You've to use update query to do so

Read - updateOne

Demo - https://mongoplayground.net/p/mrTg0DKtnrW

db.collection.update(
{ "username": "paul" },
{
  $set: {
    friends: ["alex" ]
  }
})

Aggregation demo - https://mongoplayground.net/p/yiJgkrgdeHZ

answered Apr 29, 2021 at 3:41

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

Add new field to a specific object in mongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related