I have following document on which the update needs to be done. { "_id": "Colorcode_1", "Combination": [ { "color": [ { "mixture": [ "Red", "Green" ] } ], "code": "Maroon" }, { "color": [ { "mixture": [ "Yellow", "Green" ]…
I want do an updateMany() operation on a nested array for all documents of my collection. Here is the documents format : { "number": 1, "products": [{ "name": "test", "compositions": ["water", "sugar"], }] }, { "number": 2, "products": [{ "name":…
I'm using the MongoDB version 4.4, I'm trying to return the last documents inserted in the last 24 hous, and i need to run this query every day, because of this, i don't set the date manualy, I need to…
How do I fetch only the first element from the "topicsName" array? Data I have input: { "_id" : ObjectId("606b7046a0ccf72222c00c2f"), "groupId" : ObjectId("5f06cca74e51ba15f5167b86"), "insertedAt" : "2021-04-05T20:17:10.144521Z", "isActive" : true, "staffId" : [ "606b6c34a0ccf72222c5a4df", "606b6c48a0ccf722228aa035" ], "subjectName" : "Maths", "teamId" :…
I have two tables that i want to join. Tables : users, rooms. use myDB; create table users( userId char(12), pseudo varchar(24) ); create table rooms ( roomId char(24), userIdFrom char(12), userIdTo char(12) ); insert into users values('000000000001','A'); insert into…
I have two collections: Car Drive Histories and Car Geolocations. For the purpose of analyzing drive patterns I have to aggregate driving histories and link them to car geolocations. I've used $match and $project aggregation stages to get drive history…
Error: throw er; // Unhandled 'error' event TypeError: Cannot read properties of null (reading 'items') at C:UsersshivaDesktopWeb Developmenttodolistapp.js:105:17 getting the error in the 1st app.post method -> else statement. stuck at it for almost a day. ps: code might not…
I appreciate any help in such case. Collection in MongoDB (now only 4 documents for demonstration purpose): { "_id" : ObjectId("62684847e9594c65cbaa5d85"), "agentId" : NumberInt(1), "agentName" : "Yardi Gaondi", "policyList" : [ { "receivedDate" : ISODate("2022-03-23T04:46:15.000+0000"), "policyStatusDetail" : [ { "policyStsCode"…
I have the following Array of data: { _id: 5f5726ef7d475a61a95c5e0c, attributes: [ { values: [ { name: '1' } ], }, { values: [ { name: '2' } ] } ], attr1: [ { name: "Study Code" }, { name:…
I have a requirment of inverting an object keys & values. I have following type of data: [ "elements": { "title": "elem_1_6_title", "sub_title": "elem_1_6_sub_title", "media": "elem_1_6_media", "button": "elem_1_6_button", "give_us_call": "elem_1_6_give_us_call" }, "elements": { "title": "elem_1_6_title", "sub_title": "elem_1_6_sub_title" }, "elements": {}…