Scenario Example Mongo DB documents Doc 1 { _id 123 Customer: customer A State: TX City: Houston checksum: 1111 IsBundlled: } Doc 2 { _id 1234 Customer: customer B State: TX City: Houston checksum: 1111 IsBundlled: } Doc 3 {…
Here is the sample document { "pId":12345, "charges": { "key1": "10.0,11.0,12.0,13.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0", "key2": "22.5%,12.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%,22.5%", "key3": "271.95,371.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,271.95,394.45,271.95,394.45", ... } } Charge keys are dynamic. I wanted to fetch the requested index values from charges Ex: input index is (1, 2) the expected…
I have data on a MongoDB collection stored in documents like these: { "_id": "657c54befca2b6a2cdd935ba", "data": { "name": "Bob", "surname": "xxx", "age": "20", }, "header": { "data": "1702646974156", } "_class": "Prova" } { "_id": "657c54befca2b6a2cdd935bb", "data": { "name": "Tom", "surname":…
Supposed I have the following data: Time Submitted 1 True 2 True 3 True 4 False 5 False 6 False My goal is to get either the the oldest unsubmitted OR the newest submitted. This is for loading user timesheets,…
Im writing a mongodb aggregate pipeline. My documents are of the form below : { name: "01" tags { tag_01: { a: "a01-val", b: "b01-val" }, tag_02: { a: "a02-val", b: "b02-val" } } }, { name: "02" tags {…
Is there a MongoDB aggregation query equivalent to the following SQL statement using a single MongoDB aggregation? (The two operands of the JOIN are two subqueries that also include join operations.) SELECT T1.C1, T2.C2 FROM (SELECT T3.C1 C1, T4.C2 C2…
https://mongoplayground.net/p/zIhLOT8YXLl document schema: { _id: ObjectId(); array_property: [ {_id: ObjectId(), img_array: ["string", "string"] }, { }, ... ] } query: await user.updateOne( { _id: user_id, array_property: { $elemMatch: { _id: { $in: arrary_of_id } } }, }, { $push: {…
I have the following record: id: 119, customfields: Array (2) 0: Object value: "Mr" type: "salutation" 1: Object value: "Google" type: "company" I need to update this document so that I get: id: 119, salutation: "Mr", company: "Google" Important is:…
I have a task involving the aggregation and processing of data stored in a MongoDB collection named flight_data. This collection holds a wealth of information about flights, encompassing details such as flight numbers, departure airports, arrival airports, fuel consumption, and…
compound index: { A: 1, B: 1, C: 1 } query: col.aggregate([ { $match: { B: "ssome_value", C: "some_other_value, } } ]) The query does not involve A, so the compound index is not used. I can do this to…