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
– Pierre Arlaud, Commented Nov 28, 2013 at 9:39

Parvin Gasimzade · Accepted Answer · 2013-11-28 11:53:40Z

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, 2013 at 11:53

answered Nov 28, 2013 at 9:44

Parvin Gasimzade

26.2k8 gold badges58 silver badges83 bronze badges

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

2 Comments

Parvin Gasimzade Over a year ago

You are welcome. I have updated my answer for your second question. Also if it worked, you can mark it as an answer.

ruralcoder Over a year ago

I tried this and got "The dollar ($) prefixed field '$set' in '$set' is not valid for storage." -- am using golang+mongo

Collectives™ on Stack Overflow

Update array element by id with mongo query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related