I have a MongoDB collection where I have an array of objects and I want to add an incremental index value to each element of the array of objects. Like index starts from 0 to array length - 1. db.collection.aggregate([…
Below are two collections orders and amounts. I have array of lookup data which is to be added using $addFields in orders aggregate pipeline and iterated and get total amount sum from amounts collections. db={ "orders": [ { "_id": 1,…
I have a data like: [ { "grp": "A", "seq": 1, "score": 1, x: 0 }, { "grp": "A", "seq": 1, "score": 2, x: 0 }, { "grp": "A", "seq": 1, "score": 3, x: 0 }, { "grp": "A", "seq":…
I have a database with data like this: [{ "_id": { "$oid": "664baf560b9539e48fbc6ed1" }, "name": "first assignment", "next": { "$oid": "664baf620b9539e48fbc6ed2" }, "preview": null, "date": { "$date": "2024-04-20T10:00:00.000Z" } }, { "_id": { "$oid": "664baf620b9539e48fbc6ed2" }, "name": "second assignment", "next":…
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…