Uso Monggose-paginate-v2 para hacer una paginación con nodejs, pero tengo un problema sobre cómo usar esta biblioteca con más de 1 filtro o consulta.
Mi código
exports.allData = (req, res, next) => { const { page, size, title, active } = req.query; var condition = title ? { title: { $regex: new RegExp(title), $options: "i" } } : {}; var condition2 = active ? { active: { $regex: new RegExp(active), $options: "i" } } : {}; const { limit, offset } = getPagination(page, size); var options = { populate: [{ path: 'category', select: 'name' }], sort: ({ createdAt: -1 }) }; Article.paginate(condition, condition2, { offset, limit, options }) .then((data) => { res.send({ totalItems: data.totalDocs, articles: data.docs, totalPages: data.totalPages, currentPage: data.page - 1, }); }) .catch((err) => { logger.error(req.method + ": " + req.originalUrl + ", message: " + err.message) next(createError.InternalServerError()) }); };Uso condition, condition2 en una línea, no funcionó. Gracias antes.
pass conditional query as shown below exports.allData = (req, res, next) => { const { page, size, title, active } = req.query; // query documents based on condition let query={}; if(title){ query.title={ $regex: new RegExp(title), $options: "i" } } if(active){ query.active={ $regex: new RegExp(active), $options: "i" } } const { limit, offset } = getPagination(page, size); var options = { populate: [{ path: 'category', select: 'name' }], sort: ({ createdAt: -1 }) }; Article.paginate(query, { offset, limit, options }) .then((data) => { res.send({ totalItems: data.totalDocs, articles: data.docs, totalPages: data.totalPages, currentPage: data.page - 1, }); }) .catch((err) => { logger.error(req.method + ": " + req.originalUrl + ", message: " + err.message) next(createError.InternalServerError()) }); };