How to get and check a field from another collection in mongodb?

Question

Node.js

There are two collections: products, categories. The task is to display products whose category status is true. The product collection looks like this:

Schema({
    name: {
        type: String,
        required: true
    },
  category: {
        type: Schema.Types.ObjectId,
        ref: 'categories'
    },
})

The category collection looks like this:

Schema({
    name: {
        type: String,
        required: true
    },
   status: {
     type: Boolean,
     default: true
   }
})

Answer 1

const workingCategories = await Category
.find({magazineId: req.StoreApiID, status: {$ne: false}}, {"_id": 1})
Products.find({category: {$in: workingCategories}})