Need mongodb query : if I get a order , vendorID in input params that already exists with specific orderNumber I need to update it in orders array by replacing the whole existing order element with that orderNumber with newly…
I have the following collection: [ { "_id": 1, "favorite": { "color": "red", "foods": { "fruits": "banana", "fastfood": [ "burger", "sandwich" ] } } }, { "_id": 2, "favorite": { "color": "green", "foods": { "noodles": "ramen", "fastfood": [ "fries", "burger",…
db.inventory.aggregate( [ { $lookup: { from: "order", localField: "_id", foreignField: "item_id", as: "inventory_docs" } } ] ) The $lookup is joining based on the item_id field, which is indexed. If 100,000 documents pass through this $lookup, it increased the query…
How to query the "car" collection, which stores a document for every car, and retrieve all cars that include specific keywords in their names. Then, find the latest "carInfo" document for each of these cars and return only the cars…
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…
I'd like to take weekly, hourly report of data based on date field from mongodb, for doing so, have tried to add new field called "difference" using addFields stage before the match stage and then try to use that "difference"…
I would like to iterated cross KV (NoSql,Redis) Target in MLRun without specification of primary key(s) also, but I saw only ability to get specific KV item(s) based on specific key(s). I have to use only unique items, not duplicit…
I have the following txt file hset '0' firstName 'Abel' lastName 'Spencer' birthday '29992291634' gender 'male' task 'farmer' zipcode '1845AP' hset '1' firstName 'Erick' lastName 'Leonard' birthday '29632181211' gender 'female' task 'engineer' zipcode '1382FS' hset '2' firstName 'Janice' lastName 'Montes'…
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 db like this [ { _id: ObjectId("1"), name: "John Doe", age: 25, address: { street: "123 Main St", city: "New York", state: "NY", zip: "10001" }, images : [ { url: "http://www.example.com/image1.jpg", caption: "Image 1" type: "jpg"…