Let's suppose a collection has N documents and each document has an array field with M subdocuments. For a query that uses a $elemMatch on the field with the M subdocuments to filter and findMany documents of this collection, would…
I am struggling with avatar URL update in nested objects array persisted in MongoDB. Avatar URL needs to be updated from "https://old.com/image.jpg" to "https://new.com/image.jpg" The document structure is at the end of this post. I need to update the avatar…
Having a documents collection ordered by field, I want to group documents by other field but only adjacent documents should be grouped. Like so: [ {order: 1, state: 'one'}, {order: 2, state: 'one'}, {order: 3, state: 'one'}, {order: 4, state:…
I have a collection which contains balance object that needs to be flattened and the fields within that object need to renamed based on another flag in collection - [ { "id": "1234", "documentType": "IV", "balance": { "total": 100, "openBalance":…
I have a document which has a field as Array of References and it is refering to the same document. I want to populate all the nested fields. The Data will be Acyclic (person -> children -> children ≠ person).…
I have a post model with the following structure: const postSchema = new mongoose.Schema( { caption: { type: String, maxLength: 2000 }, creator: { type: mongoose.Schema.Types.ObjectId, ref: "User" }, }, { timestamps: true } ) The creator field references the…
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: […