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…
I trying to match the data in Subarray for some reason it is grouped like this. Data : { "_id": 1, "addresDetails": [ [ { "Name":"John", "Place":"Berlin", "Pincode":"10001" }, { "Name":"Sarah", "Place":"Newyork", "Pincode":"10002" } ], [ { "Name":"Mark", "Place":"Tokyo", "Pincode":"10003"…
I have a document with format like this: { "f1": "v1", "f2": { "id": 1, "sub": "subv", "updatedAt": 123 } } I have an another source that give me a inputf2 object. I want to write an upsert query to…
I've been trying to create a query on documents like these: [ { "timestamp": new ISODate('2020-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2021-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2022-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_B" }, {…
I have a collection like this: { '_id' : ObjectId('6251f8556e75125f9260f333'), 'name': 'jojo', 'profile': 'jojo profile', 'date': ISODate("2022-04-09T21:18:40.473Z"), 'look': [ { 'art': 'group-id', 'data': 'alma', 'dt': '1'}, { 'art': 'called', 'data': 'central', 'dt': '1'}, { 'art': 'access-time', 'data': 108000, 'dt': '1'}…