Is there a way to filter this request with mongoose?

I need to make a query of all products but only with the category status in true,

The model of my products is something like this:

const ProductSchema = Schema({
name : {type: String},
category: {type: Schema.Types.ObjectId, ref: 'Category'}
})

Normally I would just make a query and then a filter for the products with category.

status === true, but the thing is that I’m using pagination and due to the filter my page of 15 products ends up with fewer products than 15 obviously because of the filter, so I really don’t know if I can make the filter with a population in the query, maybe something like this:

const query = await Product.find().populate('category', 'name status')
.select(['-cost']).where('category.status')
.equals(true).skip(0).limit(15)

But sadly it doesnt work, is there a way to do it or should I give up?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

You can easily achieve this with an aggregation:

const query = await Product.aggregate([
      {
        $lookup: {
          from: 'Category',
          localField: 'category',
          foreignField: '_id',
          as: 'status'
        }
      },
      {
        $match: {
          "status.status": true
        }
      },
      {
        $project: {
          "cost": 0, // disclude
        }
      },
      {
        $limit: 15
      },
      {
        $skip: 0
      }
  ])
// passed the tests in my database

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0