Hi I'm very new to MongoDB, I'm trying to get the total price and promo of the below MongoDB data with document.collection.find and $add functionality: Data: [ { "catalog":"A", "book":[ { "title":"Mermaid yang terdampar", "price":90000, "promo":15000 }, { "title":"Srigala berbulu…
db.getCollection("analytics").aggregate( [ { "$match" : { "uID" : { "$in" : [ "202003008", "20200306" ] }, "midNightTimeStamp" : { "$gte" : ISODate("2022-03-26T18:30:00.000+0000") } } }, { "$group" : { "_id" : "$midNightTimeStamp", "energyConsumed" : { "$sum" : "$energyConsumed" }, }…
"ProductCategory": [ { "_id": "6246e0d09b16cf549256ed75", "name": "Arduino Boards", "desc": "this is for demo purpose", "date": "2022-03-31T18:30:00.000Z", "products": [ { "name": "Arduino Uno R3 CH340G", "imgUrl": "", "price": "799", "desc": "", "_id": "6246e1fb9b16cf549256ed77" }, { "name": "Arduino Nano V3.0 ATMEGA 328P…
I have following json data in mongodb. [ { "_id": 1, "name": "user1", "userActivities": [ { "actionTaken": "Sign in.", "progress": "Success." }, { "actionTaken": "logout", "progress": "Success." } ] }, { "_id": 2, "name": "user2", "userActivities": [ { "actionTaken": "Sign…
I am working on an app that uses MongoDB (I use Mongoose) as its database. I have a question, suppose I have this kind of schema: [{ "user_id":"2328292073" "username":"Bob", "subscriptions":[ { "id":"38271281, "payments":[ { "id":"00001", "amount":"1900" }, { "id":"00002", "amount":"2000"…
Hello how to change an id of document to diffrent when some ids are equal? I want to change some of employees id_director to object id thats is equal to id_director. I mean for example, when some document have id_director…
A collection has an indexed involved field_A. But field_A is not required. So what happens if some documents do not have this field? Will the index still work for documents that do have this field?
I have the following Mongodb document. { "_id" : ObjectId("62406bfaa1d66f8d99c6e97d"), "skill": "Programming Language" "supply" : [ { "employeeName" : "A1", "skillRating" : 3 }, { "employeeName" : "A2", "skillRating" : 4 }, { "employeeName" : "A3", "skillRating" : 4 },…
I'm trying to do a lookup from collection1 to collection2 using attachments.collection2_keys (an array), and at the same time filter collection1 where collection2.type is typeA, for any key in attachments.collection2_keys. I believe this query should work, but it returns no…
I am trying to update the name of a key inside an object of an array and annoyed due to the inability to make the queries work. I have tried this How rename nested key in array of object in…