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') }…
My MongoDB database has the 'interviews' collection whose document structure is similar to this: { "_id" : ObjectId("632b97b0f2bd3f64bbc30ec8"), "agency" : "AG1", "year" : "2022", "month" : "9", "residents" : [ { "sequential" : 1, "name" : "Resident 1", "statusResident" :…
I am trying to POST to an endpoint and update a users profile with a collection that is associated with their USERID. I keep getting a 401 unathorized error THE ROUTER: router.post(`/newfixture/:id`, async (req, res) => { let fixture =…
I have this function: const getXNumberOfDocuments = async function getXNumberOfDocuments( page, results_per_page ) { /*************************************************** */ results_per_page = parseInt(results_per_page); let x_number_of_documents = await Document.find() .populate([ { path: "user", populate: { path: "profile", select: ["profileImageURL"], }, }, ]) .limit(results_per_page) .skip(results_per_page *…