update nested array with arrayFilters

Question

I've seen example like this or this SO question where we can easily use the positionnal $ operator to update an object in an array.

I'm trying to do the same thig but I must use an object sub-property.

Exemple:

// Data model:
UserSchema = new Schema({
permissionsPerOrganization: [{
    organization: {
        type: ObjectId,
        ref: 'Organization'
    },
    role: {
        type: ObjectId,
        ref: 'Role'
    }
}],

I must update Role in permissionsPerOrganization with an exact _id.

Here is what I have:

this.activeSchema.findByIdAndUpdate(
    { _id: user._id, 'permissionsPerOrganization.organization._id': org._id },
    { 'permissionsPerOrganization.$.role': roleId },
    {
        new: true
    })

I also have tried with the new $[identifier] syntax which seem made for that kind of use case but it fails...

Have you got a clue please ?

score 2 · Accepted Answer · answered Jul 20 '18 at 17:27

2

You can try with arrayFilters in following way

db.collection.update(
  { "_id": user._id }, 
  { "$set": { "permissionsPerOrganization.$[array].role": roleId  }},
  { "arrayFilters": [{ "array.organization": org._id }], new: true }
)

answered Jul 20 '18 at 17:27

Ashh

44,693
14
105
132

1

Wow !! Thank you, I think I was misunderstanding the concept of object._id – TOPKAT Jul 20 '18 at 18:55
Sorry, spoke a bit too quick...this doesn't update nothing in my collection but doesn't throw error... – TOPKAT Jul 22 '18 at 12:28
1

You need to cast your id to `ObjectId` then it will definitely work – Ashh Jul 22 '18 at 15:18

update nested array with arrayFilters

1 Answers1