I really don't understand how to improve the performance of my query using index. db.Vendite.aggregate([{$group: { _id: { anno: "$anno", mese: "$mese", cod_age: "$cod_age", cod_int: "$cod_int", cod_cli: "$cod_cli", cod_linea_comm: "$cod_linea_comm", cod_sett_comm: "$cod_sett_comm", _art: "$cod_art"}, vendite_quantita: { $sum: { $add: […
I have this Mongo document { _id: ObjectId('6616851ed50d6d1451fa8176'), phone: "+7(926)458-54-52", name: "Aboba" } I want to find that document if user inputs 7926, but also my filter is filtering another field as well. I am filtering with regex phone or…
I'm trying to retrieve one specific object from an existing array inside the DB document, using wildcards $near and $geometry. I have a model that looks like this: const schema = new mongoose.Schema({ name: {...}, email: {...}, ... locations: […
Here I just need to look up three tables first need to get all subjects from the subject table according to classid and boardid then from the content table we need to get all topic and content details and group…
I have this document structure: { "name": "ab", "grades": [ { "grade": "A", "score": 1 }, { "grade": "A", "score": 12 }, { "grade": "A", "score": 7 } ], "borough": "Manhattan2" } Assignment is to write a query to find…
I have this document structure in my collection: { "grades": [ { "grade": "A", "score": 8 }, {"grade": "A", "score": 7 } ] } I need to filter for those documents when their score is divided by 7 has 0…
When an optional key in a collection is queried , performance varied with respect to the following two queries. Good response : When it queried with a specific value - a value other than null, it resulted good response time.…
Given multiples documents containing a key named userId, where this key is always an object: { "_id": { "$oid": "22fc6b11a0ff111d598b114f" }, "userId": { "KEY1" : ["..."], "KEY2" : ["..."], "KEY3" : ["..."], "KEY4" : ["..."] }, } It will always…
I have a collection of data like this: { "items": [ { "product": { "name": "prod1", "price": { "pledge": 1, "cost": 19 } } }, { "product": { "name": "prod2", "price": { "pledge": 2, "cost": 10 } } } ]…
I have list of mongo documents [ { "created_at": "2024-03-15T18:11:18.687", "updated_at": "2024-03-15T18:11:28.945", "fields": { "contract_first": [], "contract_second": [ { "position": "Bob" } ], "uuid": "bf031b46-ec33-4c61-ad33-a3ad2cbeb9cb" }, "id": "65f46520928f6fd496ffbe6d" }, { "created_at": "2024-03-15T18:11:18.687", "updated_at": "2024-03-15T18:15:26.838", "fields": { "contract_first": [ { "position":…