How to update mongodb array values

Question

I have a document stored in mongodb like this

"Fiction" : [
           {
                   "SNo": "1",
                   "authorName" : "Enid Blyton",
                   "bookName" : "Secret series",
                   "Amount" : 115
           },
           {
                   "SNo": "2",
                   "authorName" : "Enid Blyton",
                   "bookName" : "Mystery series",
                   "Amount" : 150
           }
   ]

I would like to update the amount from 115 to 135.

I tried to update the value like this.

db.fiction.update({"Fiction.SNo":"1"},{$set:{"Fiction.Amount":135}})

But I get a error.

The error is

cannot use the part (Fiction of Fiction.Amount) to traverse the element

Can anyone help on this, I need to implement this to work from python.

db.fiction.update({"SNo":"1"},{$set:{"Amount":135}})

Sundar Singh
– Sundar Singh

2016-01-05 06:50:25 +00:00
Commented Jan 5, 2016 at 6:50 — Sundar Singh
– Sundar Singh, Commented Jan 5, 2016 at 6:50

chridam · Accepted Answer · 2016-01-05 06:41:38Z

1

Use the $ positional operator in your update as this identifies the element in an array to update without explicitly specifying the its position in the array:

db.fiction.update({"Fiction.SNo":"1"},{$set:{"Fiction.$.Amount":135}})

answered Jan 5, 2016 at 6:41

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Comments

Suhas Shelar · Accepted Answer · 2016-01-05 07:11:38Z

1

The $ operator is used to iterate through the array list while updating.

Your query would be : db.Fiction.update({"Fiction.SNo":"1"},{$set:{"Fiction.$.Amount" : 135}})

answered Jan 5, 2016 at 7:11

Suhas Shelar

9832 gold badges10 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to update mongodb array values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related