I have written a MongoDB query that looks like this: db.collection.aggregate([ { $group: { _id: null, categories: { $addToSet: "$category" } } }, { $project: { _id: 0, categories: 1 } } ]) but the result is: [ { "categories":…
I have this document. { "_id": "1", "name": "KP", "points": 20 }, { "_id": "2", "name": "Josh", "points: 30 }, { "_id": "3", "name": "Angelo", "points": 50 } How do I get the sum of all fields (should be 100)…
I have a MongoDB Collection with objects of type: { id: 1223 items: [{ length: 12.233333, }, { length: 4.2323232323232, }] } How can I update the length of each item by rounding to 2 decimals.
I've been trying to flatten a field of array that occasionally has a nested array when its size is 1 as you can see in example below. (This happened due to a previous error I made with updateMany() while trying…
Can you guys help me with this problem? Example: Data: { _id: "63f69650e820990f82dca60b", ..., transactions: [ { ..., fee: "100", ... }, { ..., fee: "200", ... } ] } I want to add a total_fee field to calculate total…
I have 2 collections, a parent and a child collection. The parent knows which children are linked. The parent: { _id: ObejctId; linkedChildren: ObjectId[] } I now wanna find the most efficient way, to find the children which are not…
I am using this code in MongoDB aggregation: { date: ISODate() } It's generating current date in ISO format for every document. How can I generate random ISO date for every document?
I'm trying to populate a double array object but in an aggregate so I am utilizing the $lookup function. The collection looks something like this: { foo: [ { bar: [ { _id: ObjectId('63f508eedd2962118c37ea36') } ] } ] } My…
Can you help me with a situation... I Have this Json but I would like to format the field trackingID like "TR000000012345BR". How can I pad a trackingId with letters and zeros on the left and letter on the rigth…
When aggregating a collection with the following pipeline stages let ap = [{ $group: { _id: { year: { $year: '$itemDate' }, month: { $month: '$itemDate' }, }, count: { $sum: 1 }, }, }] I receive something like this...…