router.get('/mypage/myreport-comment', catchAsync( async(req, res) => { const { id } = req.user; const { page } = req.query; const totalPost = await Comment.find({'reports.user': id}).populate('reports.user'); //.countDocuments({}); let { startPage, endPage, hidePost, maxPost, totalPage, currentPage } = myPageCommentPaging(page, totalPost); const comments =…
I am trying to create a multitenant DB with node js and MongoDB, and it works fine, I can create a new database with a tag, for example: main database store, tenant: store_fool, and each tenant has their tables (collections).…
I have three schemas(BlogSchema, UserSchema, commentSchema) in MongoDB. How can I populate the nested data. BlogSchema: const blogSchema = new mongoose.Schema({ title: { type: String, required: true, minLength: 5 }, author: String, user: { type: mongoose.Schema.Types.ObjectId, ref: "User", }, comments:…
I would like to know how I can make a query to the database bringing all the results that meet the 'store' {name} field, but this 'store' is saved with '_id' and I use .populate() to bring me the info…
user.ts import mongoose from "mongoose"; const UserSchema=new mongoose.Schema({ _id:mongoose.Types.ObjectId, name:{ type:String, require:true }, email:{ type:String, require:true }, password:{ type:String, require:true, }, liked:[{ type: mongoose.Types.ObjectId, ref:'blogs', require:true }], myBlog:[{ type: mongoose.Types.ObjectId, ref:'blogs', require:true }] }) module.exports=mongoose.models.users||mongoose.model('users',UserSchema) blogs.ts import mongoose from "mongoose";…
Lookup: const course = await mongoose.model('Course').aggregate() .match({ _id: new mongoose.Types.ObjectId(id) }) .lookup({ from: 'User', foreignField: '_id', localField: 'userId', as: 'user' }) Course schema: const CourseSchema = new Schema({ title: String, userId: { type: mongoose.Types.ObjectId, ref: 'User' }, }, { strict:…
I have a summary schema with a structure like this { sender: { type: mongoose.Schema.Types.ObjectId, ref: "User", required: true, }, summary: { type: String, }, sent: { type: Date, default: Date.now, }, } ); then a convo schema: NOTE: summary…
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 :-…
Banged my head against the wall for past 3-4 hours and checked countless articles here on StackOverflow but could not get my response to populate an array correctly. Using Express.js with Typescript, MongoDB and mongoose. Issue is when I get…