I have a collection of documents that each contain arrays. the output i want is the unwinded array elements filtered down by a certain criteria. i can do this by doing: db.collection.aggregate([ { $unwind: "$myArrayField" }, { $match: { "myArrayField.myCriteriaField":…
I have a collection made like this [ {timestamp: xxx, type:'start'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'start'}, {timestamp: xxx, type:'log'}, {timestamp: xxx, type:'log'} ] how do I aggregate the start event and the log…
I have a query in MongoDB like so collection.find( {$and:[ {origin:{ $in: countries }}, {brand: {$in: brands}} ]} ).toArray(); If both the arrays countries and brands have some values, the query will correctly return documents that have both the specified…
NOTE: All dates are waffle, i'm just testing. The options from the discord command are not being saved into the mongodb database. When looking at the database viewer, it seems that it's not recognising that the new options aren't a…
Here is what my route component and its loader function looks like: import { LoaderFunctionArgs, json } from "@remix-run/node"; import { useLoaderData } from "@remix-run/react"; import { ObjectId } from "mongodb"; import { unverifiedAccountsColleciton } from "~/db"; interface JsonResponse {…
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 am trying to set up an Express.js application running in a Kubernetes pod to connect to a MongoDB Atlas database. I've set up an egress droplet to control and log the outbound traffic from the cluster. The IP of…
I'm pretty new to MongoDB and I need to group the sum of the total of all invoices for each unique date in all the documents in a collection. This is a summary of the collection, where data is stored…
Needs to do a data aggregation that summarizes the data in the root as well as in the sub-table Having such input data [ { id: ID, points: 10, sources: [{ sourceId: 's1', sourcePoints: 6, }, { sourceId: 's2', sourcePoints:…