in MongoDB I want to group an array of documents that is nested in another document without it affecting the parent document. Database: db={ "users": [ { "firstName": "David", "lastName": "Mueller", "messages": [ { "text": "hello", "type": "PERSONAL" }, {…
I have mongo collection with objects with 2 fields: available_from and available_to Mongo collection: [ { "_id": ObjectId("66ed4d5ede0184e906f9397a"), "available_from": ISODate("2024-09-20T00:00:00.000Z"), "available_to": ISODate("2024-09-30T00:00:00.000Z") } ] I want to get all dates which are in specific array For example my input is:…
Currently by default when an expensive query is performed we apply a limit (as well as a time limit) to prevent a query from taking too long. We have a few simple indexes and are not ready to add any…
I have a data set that I am "mapping" into different names. Using Mongodb 7.0. I am using aggregate I am at the "$project stage { _id: 0, "First Name": "Executive First Name", "Last Name": "Executive Last Name", "Title": {…
Currently, I have these MongoDB documents: { "_id" : ObjectId("someId1"), "employeeId": 1, "vehicleName": "accord" }, { "_id" : ObjectId("someId12"), "employeeId": 1, "vehicleName": "camry" }, { "_id" : ObjectId("someId3"), "employeeId": 2, "vehicleName": "civic" }, { "_id" : ObjectId("someId4"), "employeeId": 2, "motorcycleName":…
I have this schema:{ key: [] }. I want to convert it to { key: { foo: number } }. This is the query I came up with: db.collection.update({}, [ { "$set": { key: { foo: 43 } } }…
Does anyone know how to add an array element to a mongodb array and set a "virtual" order to the size of the array, all in an atomic operation? So, something like: db.users.updateOne( { _id: 1}, { $addToSet: { images:…
I have one collection that the structure of the record look like this, { _id: ObjectId('66a544dc3a8dff9aaaf65343'), user_type: "USER", status: CREATE } The explanation of each field: _id : ID generate by MongoDB user_type : the record's user type . Can…
Here I'm adding the Mongo playground URL how my schema structure look like Now I want 3 unique array elements which are mostPurchased, latestRewards and suggestedRewards. So I'm trying to achieve by using $facet { $facet: { mostPurchased: [ {…
I was looking for a way to convert a positive integer into a binary array inside a mongoDB aggregation pipeline. There is $bit operation which can't be used inside an aggregation pipeline. This question is regarding mongoDB version 6.0 and…