Update array element by id with mongo query

Question

Is there a query to update sc from 15 to let's say 17 for array element with id 2 for _id 1? I've this structure in mongodb:

  { _id: 1,
    lb: [
       {
          id: 2,
          sc: 15
       },
       {
          id: 3,
          sc: 16
       }
        ]
  }
  { _id: 2,
    lb: [
       {
          id: 5,
          sc: 34
       },
       {
          id: 6,
          sc: 12
       }
        ]
  }

I have one more: is there a way to write a query to update as you just said and if there is no array element with updated id, insert a new one. I don't want to make two queries - first to check if element exist and update it, second to append it if there is no such. It would be nice to append it in one query. Thanks. – user3045201 1 hour ago

Isn't it the element with id 1 in your example? sc is 15 for the first element of your array. — Pierre Arlaud, Nov 28 '13 at 09:39

Parvin Gasimzade · Accepted Answer · 2013-11-28T11:53:40.610

38

You can update it using the following query :

db.myCollection.update({"_id" : 1, "lb.id" : 2},{$set : {"lb.$.sc" : 17}})

AFAIK, It is not possible to do what you want in a single query. You have to make seperate queries for each of them.

edited Nov 28 '13 at 11:53

answered Nov 28 '13 at 09:44

Parvin Gasimzade

25,180
8
56
83

You are welcome. I have updated my answer for your second question. Also if it worked, you can mark it as an answer. – Parvin Gasimzade Nov 28 '13 at 11:54
I tried this and got "The dollar ($) prefixed field '$set' in '$set' is not valid for storage." -- am using golang+mongo – ruralcoder Jun 20 '21 at 04:08

Update array element by id with mongo query

1 Answers1

Linked