How to update data in mongodb?

Question

This is my actual structure of my collection

db.collection.find().pretty()
{
    "_id" : ObjectId("557914833ac61e518e6103ab"),
    "dataValue" : {
        "value1" : [
            "value1 A",
            "value1 B"
        ]
    }
}

I want to insert like default in dataValue

db.collection.find().pretty()
{
    "_id" : ObjectId("557914833ac61e518e6103ab"),
    "dataValue" : {
        "value1" : [
            "value1 A",
            "value1 B"
        ],
        "default" : [
            "default A",
            "default B"
        ]
    }
}

Please help me

https://docs.mongodb.com/manual/reference/method/db.collection.update/ — Alex, Jul 07 '17 at 12:43
Possible duplicate of [Add new field to a collection in MongoDB](https://stackoverflow.com/questions/7714216/add-new-field-to-a-collection-in-mongodb) — felix, Jul 07 '17 at 12:49

score 2 · Accepted Answer · answered Jul 07 '17 at 12:44

2

Try this:

db.collection.update(
   { _id: ObjectId("557914833ac61e518e6103ab") }, //update doc with this id
   { $set:
      {
        "dataValue.default": [
         "default A", 
         "default B" 
         ]
      }
   }
)

As per my comment: https://docs.mongodb.com/manual/reference/method/db.collection.update/

Syntax of update is (we're only using the <query> and <update> parts of this

db.collection.update(
   <query>,
   <update>,
   {
     upsert: <boolean>,
     multi: <boolean>,
     writeConcern: <document>,
     collation: <document>
   }
)

In your case, you need to use $set

dataValue.default uses dot notation to 'reach inside' the sub document, and set the property

answered Jul 07 '17 at 12:44

Alex

37,502
51
204
332

db.collection.find({dataValue.value1}).pretty() this one not working – Arav KT Jul 07 '17 at 13:28
can yu give the correct syntax for getting dataValue.value1 – Arav KT Jul 07 '17 at 13:39
what are you trying to find? What is the query? – Alex Jul 07 '17 at 13:40
db.collection.find({dataValue.value1}).pretty() i tried this one but getting SyntaxError: Unexpected token . – Arav KT Jul 07 '17 at 13:42
yes, because it's not valid!? what are you querying for... what do you want to query by? – Alex Jul 07 '17 at 13:47
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/148613/discussion-between-alex-and-arav-kt). – Alex Jul 07 '17 at 13:54
i want value1 data in my collection – Arav KT Jul 07 '17 at 13:54
for all documents? or just with id 557914833ac61e518e6103ab? – Alex Jul 07 '17 at 13:55
i want that particular dtaa – Arav KT Jul 07 '17 at 13:55
try this `db.collection.find( { }, { dataValue.value1: 1 } )` – Alex Jul 07 '17 at 13:57
SyntaxError: Unexpected token . – Arav KT Jul 07 '17 at 13:58
add quotes - `db.collection.find( { }, { "dataValue.value1": 1 } )` – Alex Jul 07 '17 at 13:59

score 0 · Answer 2 · answered Jul 07 '17 at 12:44

0

This can be achived with a simple update with a $set operator

db.collection.update({"_id" : ObjectId("557914833ac61e518e6103ab")},
{ $set: {"dataValue.default" : [
            "default A",
            "default B"
        ]}})

answered Jul 07 '17 at 12:44

Kevin Smith

13,746
4
52
77

db.collection.find({dataValue.value1}).pretty() this one not working – Arav KT Jul 07 '17 at 13:29

How to update data in mongodb?

2 Answers2