I have one data example like this one in MongoDB. { id: 628a8683fc489c315b330ade, examName : 'Final Exam', schedule: { scheduleDate : '2021-10-18T17:00:00.000+00:00' scheduleName : 'Package Test' package:[ { exclude_question:[1,2], namePackage:testing packageId:628a89c2fc489c315b330b01 } ] }, question:[ { id:1, question:'hello can u…
I was trying run a conditional group and push. I don’t know if it is possible with MongoDb aggregate or with NodeJs. I have attendance collection and shifts collection like below. And also created Playground for my current try Mongo…
I have a document like this { "_id": ObjectId("626f942bb092f78afd9dad9d"), "item_id": "external _id222", "metadata": { "item_name": "abc", "quantity": 123, "state": null }, } What I would like to do is, $inc i.e. increment the count of quantity and then update the…
Given the following data in a Mongo collection: { _id: "1", dateA: ISODate("2021-12-31T00:00.000Z"), dateB: ISODate("2022-01-11T00:00.000Z") }, { _id: "2", dateA: ISODate("2022-01-02T00:00.000Z"), dateB: ISODate("2022-01-08T00:00.000Z") }, { _id: "3", dateA: ISODate("2022-01-03T00:00.000Z"), dateB: ISODate("2022-01-05T00:00.000Z") }, { _id: "4", dateA: ISODate("2022-01-09T00:00.000Z"), dateB: null },…
I am having a huge collection of objects where the data is stored for different employees. { "employee": "Joe", "areAllAttributesMatched": false, "characteristics": [ { "step": "A", "name": "house", "score": "1" }, { "step": "B", "name": "car" }, { "step": "C",…
We have the following records in a collection: { "_id" : ObjectId("1"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("2"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("3"), "date" : ISODate("2017-03-03T00:00:00Z") } { "_id" : ObjectId("4"), "date" : ISODate("2017-02-02T00:00:00Z") }…
I have a collection of entities like: "_id" : ObjectId("123b1c231c4a460005dc658r"), "unitId" : "58bd51815744bf06e001b57b", "name" : "Main", "shortName" : "Main", "controlOperator" : "admin" I have logins ["admin", "noAdmin", "john", "jack"] and I need to count: admin : 10 noAdmin : 15…
Sample document [{ "_id": "1111", "name": "Dani" }, { "_id": "2222", "name": "Guya", "address": "Arlozorov", "city": "Tel Aviv" }] Expected output, i want to add the length field [{ "_id": "1111", "name": "Dani", "length": 2 }, { "_id": "2222", "name":…
I am new to MongoDB, I want to get data in sections from the array. { "name":"User name", "messages":[ { "message":"Message 1", "date":"2022-05-12T00:00:00.000Z" }, { "message":"Message 2", "date":"2022-05-12T00:00:00.000Z" }, { "message":"Message 3", "date":"2022-05-13T00:00:00.000Z" }, { "message":"Message 4", "date":"2022-05-13T00:00:00.000Z" }, {…
I have a collection called "datas" and the other collection is named as "aidretentionandgraduations" in a database called "challenge". Both collections have similar values stored in different field called unitId and Unitid, their values should be used to merge those…