How to insert an element to MongoDB internal list?

MongodbMongodb Query

Mongodb Problem Overview


I have the following doc stored in MongoDB:

{
    name: 'myDoc',
    list: [
        {
            id:1
            items:[
                {id:1, name:'item1'},
                {id:2, name:'item2'}
            ]
        },
        {
            id:2
            items:[
                {id:1, name:'item1'},
                {id:3, name:'item3'}
            ]
        }
    ]
}

I found a way to add an element to 'list' using $addToSet but I couldn't find a way to add to a specific list of 'items' an item.

e.g. I get the following:

{id:5, name:'item5'} 

and I want to add it to the element's item in the list with id:2.

Mongodb Solutions


Solution 1 - Mongodb

One way of doing it would be with $push:

db.col.update(
    { name: 'doc', 'list.id': 2 }, 
    {$push: {'list.$.items': {id: 5, name: 'item5'}}}
)

http://docs.mongodb.org/manual/reference/operator/push/

You can also replace $push with other operators like (possibly) $addToSet to get the exact results you are looking for.

Solution 2 - Mongodb

You can use this: -

> var toInsert = {id: 5, name: 'item6'}
> db.abc.update(
            { name: 'myDoc', list: { $elemMatch: { id: 2 } } },
            { $addToSet: { 'list.$.items': toInsert } }
  )

The query part will find the document from the list array with id = 2. Then we use $ positional element to add a new element at that array index.

See positional $ operator


You can also replace list: {$elemMatch: {id: 2}} with just 'list.id': 2.

But using $elemMatch will be better, when you want to update based on multiple elements of your array. For e.g., when your matching criteria is id and some another field in the array say length: -

list: {$elemMatch: {id: 2, length: 5}}

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionGuy KorlandView Question on Stackoverflow
Solution 1 - MongodbSammayeView Answer on Stackoverflow
Solution 2 - MongodbRohit JainView Answer on Stackoverflow