MongoDB remove element from array by index
{ "_id": ..., "array": [ { "identifier": a }, { "identifier": b } ] } Is it currently possible to remove an element from an array by its index in MongoDB with a single query? I've been finding answers that…
MongoDB How to add a field to ALL embedded documents in an array
If I have some documents inside a collection. In this format: {posts: [{"name": "post1"},..., {"name": "postN"}]} What is the equivalent of this function: db.my_collection.update({}, { $set: {"posts.0.lastMod": new Date()}}, false, true) But to update all the embedded documents instead of…
MongoDB 6.0.x – No longer runs on macOS Ventura 13.1 or 13.2
Just upgraded (14.12.2022) to macOS Ventura 13.1 (22C65). Using Mongo on /usr/local/Cellar/mongodb-community/6.0.1/bin: brew services restart [email protected] Stopping `mongodb-community`... (might take a while) ==> Successfully stopped `mongodb-community` (label: homebrew.mxcl.mongodb-community) ==> Successfully started `mongodb-community` (label: homebrew.mxcl.mongodb-community) Then I run "mongosh": mongosh Now…
How do I filter objects and create a list of a specific field from the remaining objects in MongoDB?
I have a documents that looks like this: _id: ObjectId('...') name: Team A players: [ { name: Michael position: Goalkeeper }, { name: Frank position: Defender }, { name: Mike position: Goalkeeper } ] I want to make an aggregation…
Mongodb – How to get unique/distinct count from $reduce within $expr of a find query?
In my collection, I have documents which contains an array (called values) of objects, which has id and val fields. The data looks like this [ { values: [ { "id": "123", "val": true }, { "id": "456", "val": true…
Mongodb – CosmosDB – How to find most expensive queries?
I have a CosmosDB (using a MongoDB api) running at a avg load of 30% (of its RUs). Very sporadically (like twice a week) there's a huge spike that takes it to 100% for about 1-2 minutes, so I usually…
Mongodb – Javascript Function return true/false returns undefined
I currently have a problem with my function. I'm using a MongoDB Database to check is something exists and as you can see, if a data value is true, I wanna set the return value of the function to false…
Mongodb – How I can upload pictures using multer for array of objects
I am using nodeJS, express and mongoose. I am having a schema of form which also uploads multiple pictures. To upload the pictures I am using multer. In multer, I am using multer.fields() to upload the pic with specific own…
MongoDb summing number of distinct elements in string field array
I have an ip address collection: { "_id" : "uezyuLx4jjfvcqN", "CVE" : ["CVE2020-123", "CVE2022-789", "CVE2019-456"], "ip" : "1.2.3.4" } { "_id" : "dCC8GrNdEjym3ryua", "CVE" : ["CVE2020-123", "CVE2021-469"], "ip" : "5.6.7.8" } { "_id" : "dCC8GrNdEjym3ryua", "CVE" : ["CVE2020-123", "CVE2021-469"], "ip"…
Spring Boot Dynamic field – Mysql
How to handle the dynmaic fields creation in ui and mapping it to the backend in the spring boot. I have all the fields in the mysql and data storage in mongo. How to map with pojo entity to save…