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':…
I have following document on which the update needs to be done. { "_id": "Colorcode_1", "Combination": [ { "color": [ { "mixture": [ "Red", "Green" ] } ], "code": "Maroon" }, { "color": [ { "mixture": [ "Yellow", "Green" ]…
I want do an updateMany() operation on a nested array for all documents of my collection. Here is the documents format : { "number": 1, "products": [{ "name": "test", "compositions": ["water", "sugar"], }] }, { "number": 2, "products": [{ "name":…
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 tables that i want to join. Tables : users, rooms. use myDB; create table users( userId char(12), pseudo varchar(24) ); create table rooms ( roomId char(24), userIdFrom char(12), userIdTo char(12) ); insert into users values('000000000001','A'); insert into…