How can I search through mongoose schema object?

Question

I am trying to search through all the comments and return all comments created by a specific user from my mongodb how ever when i try to search the array returned is empty.

I have tried :

Comment.find({author: {$elemMatch: {username: req.params.username}}}, (err, foundComments) => {
        // Code goes here
      });

The Mongoose Comment Schema:

const mongoose = require('mongoose');

const commentSchema = new mongoose.Schema({
  text: String,
  discussion:[{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Comment',
  }],
  createdAt: {
    type: Date,
    default: Date.now,
  },
  author: {
    id: {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'User',
    },
    username: 'String',
    avatar: {
      image: String,
      imageId: String,
    },
  },
  likes: [{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'User',
  }],
  dislikes: [{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'User',
  }],
});

module.exports = mongoose.model('Comment', commentSchema);

When I run it I am expecting foundComments to be an array [ array of comments ] but I just get an empty array [].

score 2 · Accepted Answer · answered Oct 25 '19 at 11:28

2

Comment.find({"author.username":req.params.username});

answered Oct 25 '19 at 11:28

RameshN

510
7
14

score 0 · Answer 2 · answered Oct 25 '19 at 11:02

0

Comment.find({"username": req.params.username},{"discussion":1,"_id":0})

answered Oct 25 '19 at 11:02

vicky

415
2
10

How can I search through mongoose schema object?

2 Answers2