My query const users = usersWorkspaceModel .find({ workspaceId, userRole: 'supervisor', }) .select({ _id: 0, createdAt: 0, assignedBy: 0, updatedAt: 0, workspaceId: 0, }) .populate({ path: 'userId', select: ['_id', 'name', 'email'], mode: 'User', }); This returns me the following result :-…
In the structure of the Marks model, I have courseCode (String), courseTitle (String), studentMarks (Array of studentId and marks of that course ). The data stored in the marks collection: [ { "_id": "634 ...", "courseCode": "cse1201", "courseTitle": "Structured Programming…
I want to send dynamic query to the mongoose find() method. For each iteration I need to send dynamic key and value in find method. Can someone help in this and I have tried below. The query for each iteration…
I am querying the database using findOne which will return just one document. Now, I want a few of the fields of that document in one object and the other fields in the other object, both of which are wrapped…
I have a collection as [ { firstName: "John", middleName: "F", lastName: "Kennedy" }, { firstName: "Barack", lastName: "Obama" } ] I am trying to create a function that searches the collection by name. I need to concat the names…
userId in database: userId:"610405b8f3e5fb0484f5fac2" I want to update tha data by that Id,but getting 500Internal Server Error.I am trying in this way: service.ts public async updateUser( UserId: any, data: any ): Promise<any | Error> { try { return new Promise((resolve,…
I have one collection who include some value coming from sensor. My collection look like this. const MainSchema: Schema = new Schema( { deviceId: { type: mongoose.Types.ObjectId, required: true, ref: 'Device', }, sensorId: { type: mongoose.Types.ObjectId, default: null, ref: 'Sensor',…
I've ran into a bit of an odd issue with a mongoose result. I can select one value from the object, but not another. For example I'm calling Product.find({"name": {$regex: search), '$options': 'i'}}) .select('dropDate storePrice totalLikes') .limit(1) .exec((err, product) =>…
I've been struggling with what logic should I put on this one. I want the user to update his information, but I'm encountering a problem. What if the user wants to change his/her email, but keeps his username? In this…
I'll be grateful if you can help me understand an error generated by mongoose. Log Error: TypeError: Cannot read properties of undefined (reading 'name') at Object.isPOJO (C:Users[...]node_modulesmongooselibutils.js:396:38) at Object.toObject (C:[...]node_modulesmongooselibutils.js:354:15) at model.Query.Query.find (C:[...]node_modulesmongooselibquery.js:2341:22) at Function.find (C:[...]node_modulesmongooselibmodel.js:2244:13) at Object.exports.findMatches (C:[...]controllersmatches.js:13:11) at…