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 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", …
I want to filter the dataset to extract documents which were created 7 days ago OR a Month ago OR Documents created at any date. filter documents based on createdAt field in document. Dataset:- [ { "_id": ObjectId("6257047cffd61ab62864c1ae"), "type": "A",…
Say we have a collection with this document structure { "full": <string>, "first": <string>, "last": <string> } Looking for an expression in $project with the following logic if ("$full" is null or absent) concatenate ("$first", "_" , "$last") else "$full"…
I have this kind of collection named 'Message' [ { _id: new ObjectId("62641aea1fbe19349f8fba78"), text: 'Hello', user: new ObjectId("625b8f00e2464fb758263b4d"), receiver: new ObjectId("62638d3e5bcd98e7e48ca1b7"), createdAt: 2022-04-23T15:27:38.270Z, updatedAt: 2022-04-23T15:27:38.270Z, __v: 0 }, { _id: new ObjectId("6264256fc0ee5093f8d994a0"), text: 'Hi', user: new ObjectId("62638f1495b841266161b032"), receiver: new ObjectId("62638d3e5bcd98e7e48ca1b7"),…
I wish to find out all the matching documents in a collection for which the MatchCondition is false. I am trying to do this in the aggregate pipeline using match operator but that is not working. { "_id": { "$oid":…
I'm getting an empty array when using $search in mongoose. Schema const mongoose = require('mongoose'); const studentSchema = new mongoose.Schema({ name: { type: String }, }); studentSchema.index({ name: 'text' }); const Student = mongoose.model('Student', studentSchema); module.exports = Student; $search const…