How to insert into nested associative arrays in MongoDB

Question

I have a MongoDB collection that has a notes section that contains nested associative arrays (see schema below). I am having issues inserting a new note. Ideally I would like to do something like this

var label_var = '3';
db.collection.update({ _id: ObjectID(id) }, { $set: { notes.label_var : data} } ...

Unfortunately dot notation does not take variables and I can't use notes[label_var] in an update statement. Any help is appreciated.

Schema:

[
    {
        _id: GUID,
        title: 'title',
        notes: {
            '1': {
                content: 'content here'
            },
            '2': {
                content: 'content here'
            }
        }
    }
]

JohnnyHK · Accepted Answer · 2013-11-26 20:28:19Z

1

Build your $set value programmatically prior to your update call:

var label_var = '3';
var set_value = {};
set_value['notes.' + label_var] = data;
db.collection.update({ _id: ObjectID(id) }, {$set: set_value}, ...);

answered Nov 26, 2013 at 20:28

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

How to insert into nested associative arrays 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