My example schema from the Mongodb database looks something like this { "_id" : { "$oid" : "5bd761deae323e45a93cddae" } } From here, I would like to simplify this JSON format using JoltTransformJSON processor in Azure Nifi { "_id" : "5bd761deae323e45a93cddae"…
I'm learning back end development and need some help in mongodb, axios my project is a simple todo app which stores the created tasks in a mongoDB database. link of repository is here My problem is when I create a…
I have data returned as an array like this: [{ "_id" : ObjectId("65aa4921c767f95a70b8867f"), "creator" : "Henry", "date" : "2023-12-22", "channels" : [ { "key" : "HTV", "value" : 1 } ] }, { "_id" : ObjectId("65aa4921c767f95a70b8867f"), "creator" : "Max", "date"…
I'm trying to filter through millions of documents. Each document is about 7kB in size. For the moment, I'm filtering on a maximum of 8 (defined) fields, but more will be added later. Filters can be anything, like : "field":…
I have used find to fetch record which was giving me a mongoose record, then I used toJson() to convert to object so I can modify the fields. body = req.body; const data = model.find({target: body.target}); I am getting mongoose…
I want to slice array in document according to slicingIndex key available in the same document and push into an array. [ { slicingIndex: [0, 4, 7, 10], array: [ { name: 1 }, { name: 2 }, { name:…
I'm using MongoDb version 5.0.6. I have this structure: { "_id": ObjectId("60c7180d5ef87b4de490c56d"), "data": { "user": [ {"country": "Netherlands", "originalCountry": "Denmark"}, {"country": "France", "originalCountry": "Denmark"}, ] }, "_id": ObjectId("60c7180d5ef87b4de490c56d"), "data": { "user": [ {"country": "ITALIE", "originalCountry": "ITALIE"}, {"country": "France", "originalCountry": "France"},…
issue: My application in GKE is not able to connect with mongo Atlas over VPC peering , however if I run mongosh from a pod in GkE cluster manually using mongodb+srv://cluster0-pri.mongodb.net/test --apiVersion 1 --username user --password pass it works well.…
I have a node application using MongoDB 7.0.5 Community, Mongoose 7.6.8, MongoDB drivers 6.3.0 and Node version 20.10.0. I can't get this code to work: const updatedDealer = await my_model.updateMany( { CustomerId: 123, 'Vehicles.Id': { $in: IdArray } }, {…
I have a mongodb query and already created all required indices. But query still scanning all the documents in the collection. Following is the query: [ { "$group": { "driverStatuses": { "$addToSet": "$driverStatus" }, "batchAddedAt": { "$first": "$batchAddedAt" }, "cityId":…