I have a user collection in firestore and each user object has an array of references to "tasks" that they have applied to. Tasks is a separate collection as well and each task object has a user ref array as…
Suppose I have a collection called savedGamesFull. Whenever a document is created in this collection, it receives the Firebase-generated ID; I then reuse this ID and give it to another document in a parallel collection savedGamesLight. In another example, for…
I am new to mongodb and I am struggling to understand something that I think should be pretty simple, maybe you can point me out in the right direction! Lets say I have the following single document in a collection:…
Does mongodb community operator supports sharding architecture? If no what are the alternate open source operator options which supports the sharding setup https://github.com/mongodb/mongodb-kubernetes-operator/blob/master/docs/architecture.md
I have a collection of documents such as: { _id: 5, responses: [ { staff: false, timestamp: 1000 }, { staff: true, timestamp: 1500 } ] } I have a function (using $function) used to apply some custom logic with…
When i run this query: db.friendRequests.aggregate([ $lookup: { from: "users", localField: "author", foreignField: "_id", pipeline: [ { $match: { $expr: { friend_id: new mongoose.Types.ObjectId(userid), }, }, }, ], as: "userdata", } ]) It returns every entry in the collection, but…
In this case I have seen the official documentation of choreo, ballerina, but I could not find how to execute a query where I need to filter by the ObjectId, In Java I could do it by importing BSON, but…
so i have document for users with this structure in JSON format: [ { "_id": { "$oid": "6369aeb83ce0f8168520f42f" }, "fullname": "Jokona", "password": "$2b$10$MUAe7XIc/xtJTGVh/y1DeuShCARbwxCSejUbHaqIPZfjekNrn0.Yy", "NIK": "MT220047", "status": "active", "department": "Logistic", "position": "Management Trainee", "Group_Shift": "Non Shift", "role": "admin", "createdAt": 1667870392, "updatedAt":…
I have a Postgres DB, In which I am storing some analytical data in a table like a user id, city, country, source(referer), device_type(web, ios, android), etc. I wanted to show insights based on the data in the above table…
I have the mongo collection like this [ /* 1 */ { "_id" : 1, "data_id" : 1, "data_test" : "sample1", "data_list" : [ "sun" ], } /* 2 */ { "_id" : 2, "data_id" : 1, "data_test" : "sample2",…