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": {}…
I'm a learner and new at mongo. I'm trying to fetch the last records according to particular field. In SQL select * from powerandlevel group by deviceId order by desc limit 1. So in this SQL query based on deviceId…
I have those documents : {"_id" : 1, "actors" : [{"matricule" : "AVB", "name":"XXX"}, {"matricule" : "AVB", "name":"YYY"}]} {"_id" : 2, "actors" : [{"matricule" : "PMH", "name":"FFF"}, {"matricule" : "BNG", "name":"HHH"}]} I would like to get only the first document…
Here's my schema { _id : Number, user1: { _id : Number, userDetail : { userId : Number, userResult : String, } }, user2 : { _id : Number, userDetail : { userId : Number, userResult : String, } },…
I need to filter a multi-level nested array in MongoDB. The schema is as follows, { "_id": "1234", "array1": [ { "id": "a11", "array2": [ { "id": "a21", "array3": [ { "id": "a31", "status": "done" }, { "id": "a32", "status":…
I am very new in MongoDB. I am trying to make lookup in multi label nested array. My data is looks like bellow. [ { "_id": "621eedae92979fd8f0e9451d", "name": "Pallab Koley", "shifts": { "_id": "62636b9fcbda6d2b17f5cae0", …