I've been trying to modify a value in multiple arrays for a few arrays and I can't find documentation on how to do this. My collection looks like this "rates": [ { "category": "Web", "seniorityRates": [ { "seniority": "junior", "rate":…
I've got a MongoDB / Nodes aggregation that looks a little like this (there are other values in there, but this is the basic idea). [ { '$unwind': { 'path': '$Vehicles' } }, { '$match': { 'Vehicles.Manufacturer': 'FORD' } },…
db.collection.aggregate([ .... { $group: {_id: "$data.r.id", "col": {$first: "$data.r"}}}, {$project:{"o":{"$objectToArray":"$col"}}}, {$unwind:"$o"}, {$group:{"_id":null, "keys":{$addToSet:"$o.k"}}}, {$project: {"keys":1, "_id": 0}}, {$addFields: {res:{$map:{ input:"$keys", as: "a", in: {"_id":0,"label": "$$a"}}}}}, {$project: {"res":1}} ]) With my MongoDB query, the output is: { "res" : [ {…
I have the following document type: { "_id": 1, "_a": [ { "_aId": { "CC": "CA" }, "_p": [ { "_pId": { "CC": "CA", "SN": 1 }, "s": { "c": { "t": [ { "sId": 1, "language": "CA", "format": "A4"…
We have three nested arrays: principalCredits with 2 objects credits with 2 objects each awardNominations.edges with variable totals from 0 to 3 The task is to add a field to the third array of objects awardNominations.edges based on a lookup…
I was wondering if there was an actually good way to aggregate/calculate percentiles based on all data in a database. For example, data like: { 'name':'John' 'rank':5 }, { 'name':'John' 'rank':4 }, { 'name':'John' 'rank':5 }, { 'name':'James' 'rank':3 },…
I would like to create a query to calculate the average geographical position of all tree species in MongoDb.My code is here: from pymongo import MongoClient from utils import get_my_password, get_my_username from pprint import pprint client = MongoClient( host='127.0.0.1', port=27017,…
I have the following types of documents in my mongodb. How can i use a match function to check if the key2 value contains 'Mermaid / Fairy' or 'Superhero'? { _id: 123, key2: [ 'Mermaid / Fairy', 'Superhero' ] }…
"ParentType": { "Food": [ { "Name": "Burger", "FoodId": "5e3abe145c1bfb31b4e335de", "Price": 0, "Quantity": 1, "SubCategory": 0 } ], "Inventory": [ { "Name": "Small Popcorn", "InventoryId": "5e3a64245c1bfb31b4e335b7", "Price": 0, "Quantity": 1, "SubCategory": 0 } ] } I need to add UOM as…
I have "bank account" documents in a collection "economy" for a game in this format: _id: ObjectId("62a5c5d741c1059e0f498c2c") guild: 98525515134318336 user: 595415131438508070 balance: 156 bank: 100 I want to sort all of the documents that have the same guild value by…