const filterOptions = {
carColor: req.query.carColor,
languages: { $regex: `${req.query.languages}`, $options: 'i' },
incomeMonth: { $gte: req.query.incomeMonth },
incomeYear: { $gte: req.query.incomeYear },
age: { $gte: query.fromAge, $lt: query.toAge }, // age from - to
familyStatus: query.familyStatus
}
const profiles = await Profile.find(filterOptions)
.sort({ createdAt: 1 })
.limit(100)
return res.json({ success: true, count: profiles?.length, profiles })
por ejemplo, tengo varias consultas y una de las claves de idioma del tema: req.query.language, y quiero aplicar solo para este método $regex de la clave de consulta; de lo contrario, si la clave está vacía para alguna, no quiero pasarla a find( ) método
Debe completar el objeto filterOptions , de forma condicional, solo para las claves que existen.
let filterOptions = {};
if (req.query.carColor) {
filterOptions = {...filterOptions, carColor: req.query.carColor};
}
if (req.query.languages) {
filterOptions = {...filterOptions, languages: { $regex: `${req.query.languages}`, $options: 'i' }};
}
if (req.query.incomeMonth) {
filterOptions = {...filterOptions, incomeMonth: { $gte: req.query.incomeMonth }};
}
if (req.query.incomeYear) {
filterOptions = {...filterOptions, incomeYear: { $gte: req.query.incomeYear }};
}
if (req.query.fromAge && req.query.toAge) {
filterOptions = {...filterOptions, age: { $gte: query.fromAge, $lt: query.toAge }};
}
if (req.query.filmStatus) {
filterOptions = {...filterOptions, familyStatus: query.familyStatus};
}