How to implement like query in mongodb

Question

I want to make a query with multiple conditions but the like query is not working:

 exports.getAllPeoduct = async (req, res) => {
        var where = [];

        if(Common.required(req.query.shopId)) where.push({shopId : req.query.shopId});
        if(Common.required(req.query.categoryId)) where.push({categoryId : req.query.categoryId});
        if(Common.required(req.query.price)) where.push({price : req.query.price});
        if(Common.required(req.query.color)) where.push({availableColors :'/.*'+req.query.color+'.*/'});

        console.log(where);

        // if(Common.required(req.query.size)) where.availableSizes = req.query.size;

        try{
            // if(Common.required(shopId)) {

                let getAllProduct = await product.find({$or : where});

                if(getAllProduct.length){
                    Common.sendResponseBack(res, 200,message.OK ,message.getAllProductMessage, getAllProduct);
                } else {
                    Common.sendResponseBack(res, 200, message.OK, message.NoRecordFoundMessage, getAllProduct);
                }
            // } else {
            //  Common.sendResponseBack(res, 403,message.FAIL, message.passAllReqFields, null);
            // }
        } catch (err){
            logger.error( 'Error occured on '+new Date()+' with reason' + err);
            Common.sendResponseBack(res, 403, message.FAIL, message.internalErrorMsg, null);
        }

    }

What error do you get?

Arsalan Khattak
– Arsalan Khattak

2019-08-17 12:27:28 +00:00
Commented Aug 17, 2019 at 12:27 — Arsalan Khattak
– Arsalan Khattak, Commented Aug 17, 2019 at 12:27
i did not get any error in console

rajpoot rehan
– rajpoot rehan

2019-08-17 12:30:07 +00:00
Commented Aug 17, 2019 at 12:30 — rajpoot rehan
– rajpoot rehan, Commented Aug 17, 2019 at 12:30

rodrigoap · Accepted Answer · 2019-08-17 12:52:42Z

1

Try something like this:

availableColors : new Regex('/.*'+req.query.color+'.*/')

answered Aug 17, 2019 at 12:52

rodrigoap

7,49039 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement like query in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related