How to use and operator in where clause with sequelize in nodejs

Question

I want to search some rows from the database.

Phones.findAndCountAll({
        where: {
            id: (req.body.id) ?  req.body.id : { $ne: null },
            description: (req.body.description) ? { $like: '%' + req.body.description.trim() + '%' } : { $ne: null },
            price: {
                $and: {
                  {(req.body.st_price) ? {$gte: req.body.st_price}  : { $ne: null } },
                  {(req.body.en_price) ? {$lte: req.body.en_price}  : { $ne: null } },
                }
            }
        }
    })

But when I run this it doesnt work. I want to search if request.body.? exist. Should I use the between operator? How can I solve this problem?

Vivek Doshi · Accepted Answer · 2018-10-16 06:58:04Z

1

I think , you should build your query first and then use it inside sequelize :

let price_conditions = {};
if(req.body.st_price){
    price_conditions['$gte'] = req.body.st_price;
}
if(req.body.en_price){
    price_conditions['$lte'] = req.body.st_price;
}
price_conditions['$ne'] = null;

Phones.findAndCountAll({
    where: {
        id: (req.body.id) ?  req.body.id : { $ne: null },
        description: (req.body.description) ? { $like: '%' + req.body.description.trim() + '%' } : { $ne: null },
        price : price_conditions
    }
})

For More Detail : DO READ

answered Oct 16, 2018 at 6:58

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

How to use and operator in where clause with sequelize in nodejs

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