for example while performing aggregation the last(previous) stage gave me this documents { _id : ObjectId('662a416201ca2363543b6644'), name : 'location-1', startsFrom : 2, endsOn : 5, } { _id : ObjectId('662a416201ca2363543b6644'), name : 'location-1', startsFrom : 1, endsOn : 3, }…
I cannot figure to multiple fields by using $addFields for if else condition in MongoDB with Java operator. My requirement is to add Mutiple fields based of if else condition. I know how to add multiple fields bu using $addFields…
I have subscriptions collection in the database, e.g: [{ _id: new ObjectId(...), query: { size: { $in: [1, 2, 3] } } }, { _id: new ObjectId(...), query: { name: { $eq: 'Shirt' }, } }] I need to find…
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: […
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…
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.…
I am trying to find a way to query a mongodb collection: all documents whose state value of 'running' is also the latest entry inside the 'history' array should be returned. I was able to do this in C# with…
My sample document is [ { "id": 1234, "close": "11100", "products": [ { "productId": 111 } ] }, { "id": 1235, "close": "10101", "products": [ { "productId": 111 } ] } ] I wanted to fetch the documents only if…
I have the following mongo model: { "_id" : "5f5a1c1f6976570001783ab7", "date" : NumberLong(1590624000), "source" : "here", } I would like to have the number of documents, group by date, that have source field at here value for example: { "date"…
I have a collection of documents where each of the documents may have an array of teamsIds like: { "id": 1, "teamsIds": ["team_a", "team_b"] } I'm trying to write an Aggregation (doing $match stage before) that will $project the documents…