python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mongodb-update

Mongoose - How to push object in nested array of objects

I have this data structure in my MongoDB database: "menu": [ { "dishCategory":"61e6089f209b802518e2b4a4", "dishMeals": [ ...
test-img

mne_web_dev

javascript

node.js

mongodb

mongoose

mongodb-update

Votes: 0

Answers: 3

Latest Answer

Use arrayFilters to filter the nested document(s) in the array field, then $push if the filter criteria in the arrayFilters met. db.collection.update({ "_id": _id, "menu.dishCateg...
test-img

Yong Shun

Mongo DB create/update new field from existing date and time fields

In mongo db have a collection named item where I have 2 fields ItemReceivedDate - Type: Date , ex: value/data 2020-09-21T00:00:00.000+00:00 ItemReceivedTime - Type: Int. This is an 24 hours format e...
test-img

kiran vennampelli

mongodb

mongodb-update

Votes: 0

Answers: 1

Latest Answer

I would do it like this: db.item.updateOne({}, [ { $set: { itemReceivedDateAndTime: { $let: { vars: { time: { $concat: ['0000', { $toStri...
test-img

Wernfried Domscheit

MongoDB .NET Driver update Cannot use the part ... to traverse the element

I'm trying to rename a field but I end up getting an error. What could I be missing? A write operation resulted in an error. cannot use the part (Orders of Orders.Number) to traverse the element ({Or...
test-img

JonnyJon44

c#

.net

mongodb

mongodb-.net-driver

mongodb-update

Votes: 0

Answers: 1

Latest Answer

$rename operator is not able to work in updating the field name in a nested array. Instead, you need $set the existing Number value(s) to new field TestNumber with $map. Then $unset to remove Orders.T...
test-img

Yong Shun

Posts

Questions

Blogs

Jobs