I have an aggregation pipeline that groups objects and holds count for some specific field for grouped objects. You can reproduce the problem here: https://mongoplayground.net/p/2DGaiQDYDBP . The schema is like this; [ { "_id": { "$oid": "63ce93ffb6e06322db59fdc0" }, "fruit": "apple",…
My records like this [{ createdAt }, {createdAt}, {createdAt} ] I need average records per month. january => 3 records february => 2 records etc..
Example Documents: [ {"subdocument": {"value":100,"additionalValue":300}}, {"subdocument": {"value":100} // additionalValue doesn't exist on this one ] What I want: at the end of my aggregation: { "largest": // The entire first item because 300 is the highest overall value "smallest": //…
Context : I'm trying to build an architecture displaying POIs which can be at different know locations over time. I have 2 collections, pois { _id: ObjectId, name: string } locations _id: ObjectId, point: { type: 'Point', coordinates: Array<number> },…
I have a MongoDB collection named Venue with elements of type: { venue: "Grand Hall", sections: [{ name: "Lobby", drinks: [{ name: "Vodka", quantity: 3 }, { name: "Red Wine", quantity: 1 }] }, { name: "Ballroom", drinks: [{ name:…
I'm working on simple program that counts total number of special units through n number of players. I have documents similar to this (simplified), where array rosterUnits could be of length 0 to 7. There is a total of 7…
Here's an example through JS code of what I'm trying to achieve: let waiting = findSessions() // regular query for status "WAITING" let results = []; for (let w of waiting) { // Only push it to results if the…
I need to match all documents where field arr, which is an array of object Ids, has same elements of a given one no matther the position. I tried: [ { $match:{ arr: givenArr } } ] or [ {…
I have an aggregation pipeline like this in MongoDB: [ { "$match": { "event": "LOG_ACCESS", "createdAt": { "$gte": ISODate("2023-01-24T00:00:00+00:00"), "$lt": ISODate("2023-01-25T00:00:00+00:00") } } } ] That works, but I wonder if I can reformulate it using pure JSON syntax (note…
Array field in collection: "fruits": [ "fruits": [ "fruits": [ {"fruit1": "banana"}, {"fruit2": "apple"}, {"fruit3": "pear"}, {"fruit2": "apple"}, {"fruit4": "orange"}, {"fruit2": "apple"}, {"fruit3": "pear"}, {"fruit1": "banana"}, {"fruit4": "orange"}, {"fruit4": "orange"} {"fruit3": "pear"} {"fruit1": "banana"} ] I need to find those…