I have some data in a MongoDB collection that looks something like this: db.test.insertOne( { "interactions": [ { data: "keep", prompt: "prompt 1" }, { other: "keep", prompt: "prompt 2" }, { field: "no prompt" } ]} ) I want…
I'm trying to return all documents which satisfy document.field.value > document.array.length. I'm trying to do this using MongoClient in ExpressJS and was not able to find answers on SO. Here is what I have tried but this gives an empty…
Example Documents: [ {"subdocument": {"value":100,"additionalValue":300}}, {"subdocument": {"value":100} // additionalValue doesn't exist on this one ] What I want: at the end of my aggregation: { "largest": // The entire first item because 300 is the highest overall value "smallest": //…
I have a mongodb collection testdata which contains a field called insertTime. We have a requirement to delete data older than 60 days. So, previously to delete older data from the collections for all documents which are older than 60…
I'm looking to find some records from Mongo where they all fulfill some condition and that at least one of them fulfills a second, separate, condition. Example: Say records have counter & isHandled parameters (Number & Boolean respectfully). I'd like…
there is a nested mongodb document that looks like the image below. I want to do a search in the body field in this document, but I could not succeed. how can i do this search. thanks in advance I…
I am working on a node js project where I am getting the following error : CastError: Cast to ObjectId failed for value "[ [ '63e8e6e8b8a285d68b1fbd0c', '63e9951ded54221a516fc622' ] ]" (type Array) at path "labels" because of "BSONTypeError" at ObjectId.cast (/var/www/html/IssueTracker/node_modules/mongoose/lib/schema/objectid.js:248:11)…
I have the following result after a facet stage: { directComputers: [ { _id: ObjectId('6139f794f6a0af371900dbfh'), name: MyComputer_1 }, { _id: ObjectId('6319bd1540b41d1a35717a16'), name: MyComputer_2 } ], indirectComputers: [ { _id: ObjectId('6319bd1540b41d1a35717a16'), name: MyComputer_2 }, { _id: ObjectId('61f39f8ae2daa732deff6d90'), name: MyComputer_3 } ]…
I have a MongoDB collection named Venue with elements of type: { venue: "Grand Hall", sections: [{ name: "Lobby", drinks: [{ name: "Vodka", quantity: 3 }, { name: "Red Wine", quantity: 1 }] }, { name: "Ballroom", drinks: [{ name:…
I am creating a basic application to connect my Nodejs code to MongoDB but the code is not getting executed. Have attached image for the output I am getting. It is not printing to console got db connection Have checked…