If I have this collection [ { "_id": "637cbf94b4741277c3b53c6c", "text": "outter", "username": "test1", "address": [ { "text": "inner", "username": "test2", "_id": "637cbf94b4741277c3b53c6e" } ], "__v": 0 } ] and would like to search for the nested document by _id and…
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…
I have the following components up and running in a kubernetes cluster A GoLang Application writing data to a mongodb statefulset replicaset in namespace app1 A mongodb replicaset (1 replica) running as a statefulset in the namespace ng-mongo What I…
This is my test collection [ { "_id": "637cbf94b4741277c3b53c6c", "text": "outter", "username": "test1", "address": [ { "text": "inner", "username": "test2", "_id": "637cbf94b4741277c3b53c6e" } ], "__v": 0 } ] If I do t1 = await doc.find({}, 'text').exec(); console.log(JSON.stringify(t1, null, 2)); I…
I've a MongoDB collection that contains records with a field called createdAt, I want to get the last createdAt in the previous month of a given date using mongoTemplate aggregation in a spring boot application. example of a record: {…
Lets say I am having two collections named CollectionA and CollectionB, Both collection have different fields. CollectionA will have multiple documents with Same field, CollectionB contain only one document Example CollectionA { "UniqeId" :1, "Hobbies" : "Eating" }, { "UniqeId"…
This is the function I'm using MyModel.aggregate([ { $match: query }, { $sort: { 'createdAt': -1 } }, { $skip: skip }, { $limit: 10 } ], { allowDiskUse : true }); query is to filter the rows. skip is…
I have a trigger on new documents in collection A, in which I want to get a related record from the users collections. I (think) I followed the documentation to the "t", but both the collection itself comes out empty…
how to solved this issue? when im trying to install mongo compass enter image description here i dont know how to fix this issue
I need to push 1 item to array and save it to mongo if that item is not existed in array. Sample: I have a record with an array { _id: ObjectId('xxxxx'), userEmails: [ { email: '[email protected], addedAt: ISODate('xxx') }…