I need to get the sum of the "points" of the 3 most recent entries/objects under members array based on date. So, the total points should be 3000. (Person B 500, Person C 1000, and Person D 1500). How do…
My colection is a list of products with the following structure { _id name status // enum ['active','sold','reserved','pending'] . . createdAt } What I need is a sort feature along with the status value passed to the system, I ll…
Below is a block from my aggregate query, { $addFields: { destinations: { $filter: { input: "$destinations", cond: { $and: [ { $or: [ { "$$this.reported_at": { $exists: false } }, { "$$this.reported_at": { $eq: null } } ], },…
I have the following project: { '$project': { '_id': 1, 'applicationIds': { 'type': 'linux', 'refId': '$applicationIds' }, 'configurationIds': { 'type': 'linux', 'refId': '$configurationIds' } } } As long as there is at least one record in $configurationIds I will get…
I have these documents: [ { "id": 1, "condition": true }, { "id": 1, "condition": false }, { "id": 2, "condition": true }, ] In this case I want the output to be "id": 1, since it has condition as…
I have this rows of json like so: 1. {"0": 2} 2. {"2": 0} 3. {"3": 0} 4. {"4": 1} 5. {"13": 0} How to convert it into a single object? { "0": 2, "2": 0, "3": 0, "4": 1,…
I'm trying to generate the following output: type totals CostA 1500 CostB 200 CostC 300 From a table with this structure: CostA CostB CostC name date -- more columns ... The table has more columns but I want the sum…
I’ve been trying to get data from collection without using $expr inside $match pipeline stage because it’s less performant and compared to simple $match Here’s a piece of code I’ve been working on: from: 'messages', let: { "iId": "$_id" },…
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 an array： [ { id: 1, name: 1, list: [ { id: 11, name: 11, list: [ [ { id: 111, name: 111 }, { id: 112, name: 112 } ] ] } ] }, { id: 6,…