I'm trying to make a seemingly simple update to a MongoDB collection that looks like the below using Node. Collection { account_id: "ORG1", progress: [{week: 1, goal: 5000, raised: 2400}, {week: 2, goal:5100, raised: 1000}] } The goal is to…
I have a document with a nested array which looks like this: [ { "id": 1, data: [ [ ISODate("2000-01-01T00:00:00Z"), 2, 3 ], [ ISODate("2000-01-03T00:00:00Z"), 2, 3 ], [ ISODate("2000-01-05T00:00:00Z"), 2, 3 ] ] }, { "id": 2, data: []…
As far as I can tell, populate() is being called in my code (because I get an error if I give it a wrong path), but it doesn't seem to be doing anything. I searched for past question in Stack…
I have an api in nodejs, which performs mongodb aggregation, in that pipeline the date values will add through request params with the help of an api, aggregation is working fine. but these date values are not getting evaluated. my…
I have a collection in MongoDb and the data in it is as follows. [ { "_id" : ObjectId(""), "at" : ISODate("2022-03-27T11:56:00.000Z"), "personIds" : 13355, "productIds" : [ "c3cc8b62-f9f7-4845-8585-effb1efd790d", "af59b890-61b6-45a6-b2a1-32e16ba1a136" ] }, { "_id" : ObjectId(""), "at" : ISODate("2022-03-28T11:56:00.000Z"), "personIds"…
I want to search autocomplete on the following fields :contactfirstname, contactlastname and name Also, want to filter based on userid(s) first then perform autocomplete search Issue: Without filter criteria, autocomplete is working fine With filter criteria in compound query not…
I have some mongodb queries that are returning 1000 results, when I look in the mongodb.com profiler it shows me this: { "command": { "getMore": 8223354687588024000, "collection": "reservations", "batchSize": 1000, "lsid": { "id": { "$binary": { "base64": "n8eH91eURw+xpT6fNEPURQ==", "subType": "04"…
I am trying to connect a NodeJS server to an AWS documentDB cluster with TLS enabled. The NodeJS server is hosted on an EC2 instance and it's on the same VPC as the documentDB cluster. But I'm getting the following…
I have collection with numeric value in string format. I want to get distinct value sorted by numeric order. Here is the sample data and query I have https://mongoplayground.net/p/Z9VRzlHjD7J Data [ { id: "1" }, { id: "1005" }, {…
I have a collection in the following format: [ { "postId": ObjectId("62dffd0acb17483cf015375f"), "userId": ObjectId("62dff9584f5b702d61c81c3c"), "state": [ { "id": ObjectId("62dffc49cb17483cf0153220"), "notes": "these are my custom notes!", "lvl": 3, }, { "id": ObjectId("62dffc49cb17483cf0153221"), "notes": "hello again", "lvl": 0, }, ] }, ]…