How to write query for mongodb? I need to set parameter in array [duplicate]

Question

I have this doc:

{
    '_id': 123456,
    'name': 'myName',
    'state':[{'user_id':1,user_state:1},{'user_id':11,user_state:2}]
}

I need to set one more filed ,'is_active':1, in state array object, where "_id" == 123456, and user_id == 11.

As a result it should look like this:

 {
     '_id': 123456,
     'name': 'myName',
     'state': [{'user_id':1,user_state:1},
               {'user_id':11,user_state:2,'is_active':1}]
}

But I am stuck with query:

{_id: new ObjectID(123456)}, {$set:{'state':???}}

Thanks in advance

Rahul Sharma · Accepted Answer · 2017-06-13 06:45:39Z

1

Try this,

db.colection_name.update({_id: ObjectId("123456"), "state.user_id": 11}, { $set:{ "state.$.is_active" : 1 }})

answered Jun 13, 2017 at 6:45

Rahul Sharma

3562 silver badges12 bronze badges

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

3 Comments

will try now. thanks!

worked.thanks. marked your answer.

Happy to help :)