updating a data object in nested array in mongodb by mongoose

Question

i have a serious problem in updating my data . i have no idea how i can update a specific field in an object of an array in my document .

here is my Schema model :

var shiftSchema = new Schema({
Phone: String,
final: Boolean,
statusSH: String,
order: {
    startTime: String,
    finishTime: String,
    income: String,
    orders: [{
        stat: String,
        orderId: String,
        customerPhone: String,
        orderQuantity: String,
        orderCost: String,
        orderCondition: String,
        orderTag: String
    }]
}
});

when i use "find" it gives me the document and not just the object.

now how can i edit "stat" by finding "orderId" ?

Note that i do not have the index of the object that i want to update and i can just use "find"or "findOne".

i search all over the web and i couldn't find a good guide and example .

sorry for my bad english.

All tips will be appreciated. Thank You.

Jakub A Suplicki · Accepted Answer · 2020-08-12 05:42:47Z

2

You can try to run this query, to update the stat property:

shiftSchema.updateOne({
  'order.orders.orderId': 'id'
}, {
  '$set': {'order.orders.$.stat': 'newStatus'}
})
.then((result) => {
  console.log(result)
}, (e) => {
  console.log(e)
})

You can see I used positional $ operator to access an element in the array and update it without specifying the position of the element (with index).

I also used $set to replace the value of a field.

With just find or findOne you will not make the actual update.

edited Aug 12, 2020 at 5:42

answered Aug 12, 2020 at 5:37

Jakub A Suplicki

4,8211 gold badge27 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

updating a data object in nested array in mongodb by mongoose

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related