Agfdhyk

I'm getting an array of ObjectId from a query, then I need to use them inside another query.

Here is the function:

exports.getAllByShop = wrap(async(req, res, next) => {

    const products = await Product.find({ _shop: mongoose.Types.ObjectId(req.params.shopId) }).select('_id');

    // how to make this query?

    const sales = await Sale.find({ _product: { $in: [ products ]}});

    res.status(200).json(sales);

});

The result of the first query products looks like this:

[ 

  { _id: 5be3601f90e40b35547ae6b4 },

  { _id: 5be4b5a3443abf196cb4cc9a }

]

What I'm trying to achieve:

const sales = await Sale.find({ _product: { 

$in: 

  [ 

    mongoose.Types.ObjectId(prod1),

    mongoose.Types.ObjectId(prod2),

    ... 

  ]

}});

I need to find all the sales that have their _product equals to the values of the above array. Right now it doesn't work and show this message: "Cast to ObjectId failed for value "[ { _id: 5be3601f90e40b35547ae6b4 },↵ { _id: 5be4b5a3443abf196cb4cc9a } ]" at path "_product" for model "sale"". How to make this last query work?

youre inserting an array, into an array, try this instead

const productIds = products.map((v) => v)

const sales = await Sale.find({ _product: { $in: productIds }});