Updating several objects in array of objects mongoose

Question

I have schema like :

const UserSchema = new mongoose.Schema({
    skills: [{
        _id: false,
        name: String,
        level: Number,
        exp: Number
    }]
});

As example document is like :

{
    "_id": {
        "$oid": "5b0941419703f80a121c44df"
    },
    "skills": [
        {
            "name": "woodcutting",
            "exp": 1110,
            "level": 1
        },
        {
            "name": "smithing",
            "level": 0,
            "exp": 0
        },
        {
            "name": "reading",
            "level": 0,
            "exp": 0
        },
        {
            "name": "writing",
            "level": 0,
            "exp": 0
        }
    ]
}

So I just need to update exp and level of woodcutting and smithing in one query, is it possible, if possible, how? Or will I need to change all array and set(replace) with it value of skills?

Ashh · Accepted Answer · 2018-07-20 17:01:18Z

1

You can use arrayFilters from mongodb 3.6

db.collection.update(
  { }, 
  { "$set": {
    "skills.$[skill1].exp": "your_value",
    "skills.$[skill2].level": "your_value",
    "skills.$[skill2].exp": "your_value",
    "skills.$[skill1].level": "your_value"
  }},
  { "arrayFilters": [{ "skill1.name": "woodcutting", "skill2.name": "smithing" }] }
)

answered Jul 20, 2018 at 17:01

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Updating several objects in array of objects mongoose

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related