mongodb set object where key value dynamically changes

Question

In a document I have an object called farms and inside this object I would like to update key-value pairs in the following mannner. How would I do this?

$set:{"farms[${farm._id}]":{name:"a-farm", size:100}

the result would look like this(assuming farm._id = 12345)

farms:{"12345": {name"a-farm", size: 100}}

mickl · Accepted Answer · 2019-01-21 07:42:04Z

2

You can use $set and build your key dynamically using dot notation, try:

var farm = { _id: 12345 }
var path = "farms." + farm._id;
var documentId = ... // your document id

db.col.update({ _id: documentId  }, { $set: { [path]: { name:"a-farm", size:100 } }  })

answered Jan 21, 2019 at 7:42

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

mongodb set object where key value dynamically changes

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related