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…
Here see this Collection here have a record with createdAt with 14Feb and one with 16Feb, Now querying an aggregation on the collection such as I want to add an document of 15Feb as it was missing in collection with…