Given 1st block of code is the sample data and the second block is my desired output What is the query needed to add the fields of Machine Stats in MongoDB So that my desired output is this (basically addition…
I want to pull the whole nested array object if the object contains a specified string for a specific key. I'm using mongoose with nodejs: DB before deletion: { _id : 1234 fallBackData: { nestedKey: [ { arrayKey: "theValue" },…
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 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 am working on a project and it currently goes through each document to edit the field and lags a lot. { "Name" : "Susie" , "This Semester" : 10 , "Last Semester" : 0 } { "Name" : "John"…
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"] }…
how to i push value in double nested array as shown in below code !! { "_id" : ObjectId("627ce38702f566ef8e89977a"), "name" : "max", "sub" : { "type" : "maths", "grades" : [ { "semOne" : [ 7, 8, 9 ] },…
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 mongodb nodejs driver. const res = await chats.findOne({ _id: chatId }, { messages: 0, _id: 0 }); this is what i'm getting in response, i don't wanna get messages and _id property on received data { "_id": "d0fff742-4af5-4e6a-bd51-9aa47da08fb9",…
I am new to mongo and I've got a query that I am running as seen below: db.getCollection('equityprice_input').aggregate([ {'$match': {'mrsBusinessDate': '2022-05-05', 'instrument': 'other', 'sourceSystem': 'bloomberg', 'mrsTime': '17:00:00', 'dataType': 'price'}}, {'$lookup': {'from': 'equityprice_input', 'localField': 'data.securities', 'foreignField': 'data.securities', 'as': 'staticData'}}, {'$project': {'_id':…