I have the next data in my Mongo DB { sucursal: 1 productos: [ { producto: 1, kilos: 50 } ] }, { sucursal: 2 productos: [ { producto: 1, kilos: 30 }, { producto: 2, kilos: 50 } ]…
I have some data in mongoDB and i want to group and sum it in object key - value: { '_id': '1', 'value': { A: 1, B: 2, C: 3 } }, { '_id': '2', 'value': { B: 2, C:…
I have this db table: http://sqlfiddle.com/#!9/e1dd38e/7 I am trying to query it so it goes thru each category, returning each subcategory's top 3 vendor's, ordered by their total of spend (sum(amount)), the vendors outside of the top 3 will be…
I need to get two different sets of data from the same collection and if any data in any set has convergence with another data in other set combine them into one and if not convert them to a desired…
I have a query like this in mongodb: db.Product.aggregate([ { $addFields: { maxSku: { $max: '$ProductVariants.FullSku' } } }, { $group: { _id: null, value: { $max: '$maxSk' } } } ]) but how can I execute it using mongodb…
I have a list of posts: [{"name: "POST 1", {"name": "POST 2",}, {"name": "POST 1",} I want to count the number of identical names and output the maximum number. The expected result is: {"id: "POST 1", count:2} Now I wrote…
I have the following data in an orders table: revenue expenses location_1 location_2 3 6 London New York 6 11 Paris Toronto 1 8 Houston Sydney 1 4 Chicago Los Angeles 2 5 New York London 7 11 New York…
Currently, I have 3 different aggregate queries which generate different counts based on grouping of companyRegNo. Is there a way to combine these 3 queries. The employeeActions data looks like this: { "email": "[email protected]", "companyRegNo" : 105, "event" : {…
I have two collections energyOffers and energyOfferLogs. When a user deactivated their account I'm looking for all the remaining active energyOffers where the entity of the user is in the assignees array, not in the declinedEntities array and the offerValidTill…
I have the below dbData wherein in the contracts collection, there is an attribute called via which is an array that holds the mongoose ids of depot entries. db={ "contracts": [ { "_id": ObjectId("630c9e23fb146c4b3b801b9e"), "detention_id": [], "route_exclude": false, "trip_count": null,…