adding data in fields of a single document in mongodb

Question

I have this data:

_id : 1
status:1, 
name:"name",
details:
{ 
  crm:115, 
  webs: 
    { tag:"blog" , url:"http://..."}, 
  contacts:
    {
      _id:1,
      name:"me", 
      phones:
        { tag:"home", number:"123..." },
        {tag:"mobile", number:"123456789"}
    }
}

I want one more entry in "phones" with {tag:office", number:"9823..."}

What would be the command/query for that?

It's not clear what you're asking, can you clarify your question? — JohnnyHK
– JohnnyHK, Commented Jul 11, 2013 at 12:27
Please do not refer to another question. Create a seperate, stand-alone question with a clear question, a clear schema and the problem you are unable to solve. Thanks ;) — Remon van Vliet
– Remon van Vliet, Commented Jul 11, 2013 at 12:41
Here is it, the above mentioned is my final question, sorry for the previous one. :) — Hitesh
– Hitesh, Commented Jul 11, 2013 at 12:46
Please show the code that you've tried. It looks like you want phones to be an array, so, you'd need to use $push: docs.mongodb.org/manual/reference/operator/push — WiredPrairie
– WiredPrairie, Commented Jul 11, 2013 at 12:50
db.abcd.update( { _id : 1 }, { $push: {details: { contacts: { phones: { tag:"office", rname:"9823" } } } } } ); — Hitesh
– Hitesh, Commented Jul 11, 2013 at 13:03

Derick · Accepted Answer · 2013-07-11 14:27:28Z

2

You can easily push this into the array with the following query (I had to modify the JSON you pasted, as it was not valid a little):

db.collection.drop();
db.collection.insert( {
    _id : 1,
    status: 1, 
    name: "name",
    details: { 
        crm:115, 
          webs: {
            tag:"blog",
            url:"http://..."
        }, 
        contacts: {
            _id: 1,
            name: "me", 
            phones: [
                { tag: "home", number: "123..." },
                { tag:"mobile", number:"123456789" }
            ]
        }
    }
} );

db.collection.update(
    { _id: 1 },
    { $push : { 'details.contacts.phones' : {  tag:"office", rname:"9823" } } }
);

db.collection.find().pretty();
{
    "_id" : 1,
    "details" : {
    "contacts" : {
        "_id" : 1,
        "name" : "me",
        "phones" : [
            {
                "tag" : "home",
                "number" : "123..."
            },
            {
                "tag" : "mobile",
                "number" : "123456789"
            },
            {
                "tag" : "office",
                "rname" : "9823"
            }
        ]
        },
        "crm" : 115,
        "webs" : {
        "tag" : "blog",
        "url" : "http://..."
        }
    },
    "name" : "name",
    "status" : 1
}

edited Jul 11, 2013 at 14:27

answered Jul 11, 2013 at 13:10

Derick

36.9k7 gold badges82 silver badges104 bronze badges

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

4 Comments

Hitesh Over a year ago

When I do so I get error "Cannot apply $push/$pushAll modifier to non-array" :(

Derick Over a year ago

I actually tested with the document that you showed above. I've updated my example with the insert and find+results too.

Hitesh Over a year ago

Ok, Thank you so much for that, but suppose if I want to add new entry in contacts say, {_id:2,name:"hitesh"}.. Then, for that the following doesn't work and why? db.collection.update( { _id: 1 }, { $push : { 'details.contacts' : { _id:2, name:"hitesh" } } } );

Derick Over a year ago

That's because contacts is not an array, but just a simple document. It needs to be an array if you want to push into it. However, if you turn that into an array, then the original push to add a phone number no longer works. You can only have one of them to work. In your case, you probably want to split out contacts+phone into a different collection with a link back to the main document.

JohnnyHK · Accepted Answer · 2013-07-11 13:08:42Z

0

The value of the $push operator must refer to the array to be updated. So when the array field is embedded in other documents you need to use dot notation like this:

db.abcd.update({_id: 1}, 
    {$push: {"details.contacts.phones": {tag:"office", rname:"9823"}}});

answered Jul 11, 2013 at 13:08

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

3 Comments

Hitesh Over a year ago

Thats ok with arrays, but I haven't used arrays, so how do I query to push data in "phones", is there any other way ?

JohnnyHK Over a year ago

@Hitesh Ok, I assumed phones was an array as what you show isn't a valid doc. Can you fix phones in your example doc to show what you mean?

Hitesh Over a year ago

When I do so I get error "Cannot apply $push/$pushAll modifier to non-array" :(

Collectives™ on Stack Overflow

adding data in fields of a single document in mongodb

2 Answers 2

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related