Mongoose Querying on Array of Object or Virtual for array of Object

Question

I have the following Mongoose schema as defined on this page

const AuthorSchema = new Schema({
    name: String
});



const BlogPostSchema = new Schema({
  title: String,
  author: { type: mongoose.Schema.Types.ObjectId, ref: 'Author' },
  comments: [{
    author: { type: mongoose.Schema.Types.ObjectId, ref: 'Author' },
    content: String
  }]
});

Now I want to create a virtual on AuthorSchema to get the BlogPosts which have comments of that author.

I tried creating a virtual function but with no success

hungtran273 · Accepted Answer · 2023-01-31 13:43:48Z

1

Both virtual and methods can solve your problems:

Virtual:

// Model
AuthorSchema.virtual('blogPosts').get(function () {
  return this.model('BlogPost').find({
    comments: { $elemMatch: { author: this._id } },
  })
});

// Usage
const author = await Author.findById(id);
const blogPosts = await author.blogPosts;

Methods:

// Model
AuthorSchema.method.blogPosts= function (cb) {
  return this.model('BlogPost').find({
    comments: { $elemMatch: { author: this._id } },
  }, cb)
};

// Usage
const author = await Author.findById(id);
const blogPosts = await author.blogPosts();

answered Jan 31, 2023 at 13:43

hungtran273

1,38512 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongoose Querying on Array of Object or Virtual for array of Object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related