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 })
for example I have multiple query, and one of theme language key: req.query.language, and I wanna apply only for this query key $regex method, otherwise if empty key for any, I don't wanna pass it into find() method
You should fill the filterOptions object, conditionally, only for keys that exist.
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};
}