Edit multiple objects in array using mongoose (MongoDB)

Question

So I tried several ways, but I can't, I can modify several objects with the same key but I can't modify any with different keys, if anyone can help me is quite a complex problem

{ 
  id: 123, 
  "infos": [ 
    { name: 'Joe', value: 'Disabled', id: 0 }, 
    { name: 'Adam', value: 'Enabled', id: 0 }
  ]
};

In my database I have a collection with an array and several objects inside which gives this.

I want to modify these objects, filter by their name and modify the value.

To give you a better example, my site returns me an object with the new data, and I want to modify the database object with the new object, without clearing the array, the name key never changes.

const object = [
  { name: 'Joe', value: 'Hey', id: 1 }, 
  { name: 'Adam', value: 'None', id: 1 }
];

for(const obj in object) {
  Schema.findOneAndUpdate({ id: 123 }, {
    $set: {
      [`infos.${obj}.value`]: "Test"
    }
  })
}

This code works but it is not optimized, it makes several requests, I would like to do everything in one request, and also it doesn't update the id, only the value.

If anyone can help me that would be great, I've looked everywhere and can't find anything

My schema structure

new Schema({
  id: { "type": String, "required": true, "unique": true }, 
  infos: []
})

I use the $addToSet method to insert objects into the infos array

Please add your schema structure.

Prit Hirpara
– Prit Hirpara

2022-03-14 13:22:50 +00:00
Commented Mar 14, 2022 at 13:22 — Prit Hirpara
– Prit Hirpara, Commented Mar 14, 2022 at 13:22
I edited with the schema

Lemaaa
– Lemaaa

2022-03-14 14:18:31 +00:00
Commented Mar 14, 2022 at 14:18 — Lemaaa
– Lemaaa, Commented Mar 14, 2022 at 14:18

Prit Hirpara · Accepted Answer · 2022-03-15 12:05:57Z

3

Try This :

db.collection.update({
  id: 123,
  
},
{
  $set: {
    "infos.$[x].value": "Value",
    "infos.$[x].name": "User"
  }
},
{
  arrayFilters: [
    {
      "x.id": {
        $in: [ 
          1 
        ]
      }
    },
    
  ],
  multi: true
})

The all positional $[] operator acts as a placeholder for all elements in the array field.
In $in you can use dynamic array of id. Ex :

const ids = [1,2,..n]

db.collection.update( //Same code as it is... { arrayFilters: [ { "x.id": { $in: ids } }, ], multi: true })

MongoPlayGround Link : https://mongoplayground.net/p/Tuz831lkPqk

edited Mar 15, 2022 at 12:05

answered Mar 14, 2022 at 13:30

Prit Hirpara

1981 silver badge10 bronze badges

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

2 Comments

Lemaaa Over a year ago

But i have an array with 30k users and i only want to edit 10-15 of them not all, i also want to edit multiples values in the object

Prit Hirpara Over a year ago

In this code I have seen two object users with the same id 1. In that case I would assume that there are multiple user objects with the same id. and in my code, I have talked about how to change the field of multiple by using multiple id.

R2D2 · Accepted Answer · 2022-03-14 14:00:41Z

1

Maybe you look for something like this:

db.collection.update({},
{
  $set: {
   "infos.$[x].value": "test1",
   "infos.$[x].id": 10,
   "infos.$[y].value": "test2",
   "infos.$[y].id": 20
   }
 },
{
 arrayFilters: [
{
  "x.name": "Adam"
},
{
  "y.name": "Joe"
}
],
  multi: true
})

Explained:

You define arrayFilters for all names in objects you have and update the values & id in all documents ...

playground

answered Mar 14, 2022 at 14:00

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

3 Comments

Lemaaa Over a year ago

Yes it's that, but if i got 10 users, how can i automate this, i don't want to add 10 filters

Lemaaa Over a year ago

How can i add an array to the $set method ? I dont want to add each line manually

R2D2 Over a year ago

Btw , you can prepare array of many update operations in single bulkWrite call , check here if you want to reduce the many single calls to the database: docs.mongodb.com/manual/reference/method/…

Collectives™ on Stack Overflow

Edit multiple objects in array using mongoose (MongoDB)

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related