How to Update an Object inside an Array inside a MongoDB Collection using Mongoose

Question

This Is An Expense Tracker Application

I'm Trying to Make An Update Route where The User Can Update the Value of An Expense

For Example, I want to update the First Expense Name from Bike to Bike Rental & Amount from 250 to 500

And similarly, make a generic endpoint where the user can update any expense whenever necessary

Here A Snapshot of My Express Get Route & The Patch route which I want to fill

The ObjectID of the Entire Collection which is 607bbb07e1ebb63a3033af15 will be sent to the backend from the Frontend.

I am using Express, Mongoose.

Syed Umair · Accepted Answer · 2021-04-28 11:43:44Z

1

You can run update on the model you have created like this:

const filter = {_id :"(*User Id Here*)", "Expenses._id": "(*Expense Id Here*)"}; //check the type of _id if this doesn't work
const query = {$set: {"Expenses.$.Name" : "value"}};

User.update(filter, query);

Or,

User.update({_id :"ObjectId(pass id)", "Expense._id" : ObjectId'pass id'}, {'$set': {'Expenses.$.Name': 'name update'});

Similarly, You can do this for any key in the object provided that the key exists in it. Now this will check the

edited Apr 28, 2021 at 11:43

Syed Umair

654 bronze badges

answered Apr 27, 2021 at 17:35

Apoorva Chikara

8,8033 gold badges24 silver badges39 bronze badges

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

1 Comment

Syed Umair Over a year ago

The Above Query is getting executed however It Isn't getting updated in the database.

Collectives™ on Stack Overflow

How to Update an Object inside an Array inside a MongoDB Collection using Mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related