I apologize for the vague question description, but I have quite a complex question regarding filtration in MongoDB aggregations. Please, see my data schema to understand the question better: Company { _id: ObjectId name: string } License { _id: ObjectId…
I have all combination of compound indexes for this collection. The aggregattion query i used is: db.products.aggregate( [ { $facet: { "categorizedByColor": [ { $match: { size: { $in : [50,60,70] }, brand: { $in : ["Raymond","Allen Solly","Van Heusen"] }…
I have an "Image" collection below ( Note: labels field is an array, because 1 Image maybe have many labels) { "_id" : ObjectId("624d182b6a4e7f001ed5cd9f"), "is_deleted" : false, "labels" : [ { "_id" : ObjectId("627a0fbc12458800209dd69c"), "labelId" : ObjectId("624d14d76a4e7f001ed5c6ca"), "xmin" : 0.440625,…
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 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…
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…