i try to save data using bot command, but everytime i submit the data it will make new object, i want to make it only 1 object but everytime the same user submit data, it will automtically got changes/update, not…
Lets say I have an array ['123', '456', '789'] I want to Aggregate and look through every document with the field books and only return the values that are NOT in any documents. For example if '123' is in a…
I am relatively new to MongoDB and I am concerned that concurrent request could mutate a single document effectively causing data loss (the first write would be clobbered by the second write). DynamoDB handles this via Optimistic locking and conditional…
I'm trying to replicate data from MongoDB Atlas into an S3 data lake (not mongo's data lake) using AWS Data Migration Services, but I'm getting this error: Failed to establish a connection to MongoDB using the following parameters: 'mongodb://mongodb+srv://[theUsername]:[thePassword]@[theServer].mongodb.net:27017/?retryWrites=false' I'm…
I have data that already saved at mongoodb atlas, but i dont know how to get and display that data to my bot discord reply. This is how i submit the data const subregis = "!reg ign:"; client.on("message", msg =>…
With a MongoDB collection name department with the following structure: { "_id":99, "name":"Erick Kalewe", "faculty":"Zazio", "lecturers":[ { "lecturerID":31, "name":"Granny Kinton", "email":"[email protected]", "imparts":[ { "groupID":70, "codCourse":99 } ] }, { "lecturerID":36, "name":"Michale Dahmel", "email":"[email protected]", "imparts":[ { "groupID":100, "codCourse":60 } ] }…
I have a mongo collection (of <BsonDocument>) who could look like this: { "someProperty1": "someValue1", "users": [ { "name": "[email protected]", "displayName" : "Sample User" } { "name": "[email protected]", "displayName" : "Another User" } ] }, "someProperty2": "someValue2", "users": [ {…
Here is the collection: db.employees.insertMany([ { "data": { "category": [ { "name": "HELLO", "subcategory": [ "EDUCATION", "ART", ] }, { "name": "HELLO", "subcategory": [ "GG", "ART", ] }, { "name": "HELLO", "subcategory": [ "EDUCATION", "SHORE", ] } ] } },…
db.transaction.aggregate( [ { "$match": {"AMOUNT":{"$ne":null}} }, { "$group": {"_id":{}} }, { "$addFields": {AMOUNT:{$toDouble:["$AMOUNT"]}} }, { "$project": {"AMOUNT":{"$gt": 10000}} } ] ); Trying to fetch amount from the collection which is greater than 10000, as I'm working in MongoDB so data…
I have a document like this { "_id" : ObjectId("6228cd8e72e74fa2a4bbd76c"), "userId" : 8426, "answer" : "https://cdn.upgrad.com/resumejyotiranjana.docx", "updatedAt" : ISODate("2022-06-09T13:48:17.296Z"), "questionIdentifier" : "resumeLink", } I need to convert answer into array of objects, The existing answer will become resumeLink properties and…