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 ?

Ashh · Accepted Answer · 2018-07-20 17:27:20Z

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, 2018 at 17:27

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

3 Comments

TOPKAT Over a year ago

Wow !! Thank you, I think I was misunderstanding the concept of object._id

TOPKAT Over a year ago

Sorry, spoke a bit too quick...this doesn't update nothing in my collection but doesn't throw error...

Ashh Over a year ago

You need to cast your id to ObjectId then it will definitely work

Collectives™ on Stack Overflow

update nested array with arrayFilters

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related