How can I filter data using Sequelize?

How can I filter data using Sequelize?

You can filter data in Sequelize using the where option in your query. For example, Model.findAll({ where: { age: 25 } }) will return all records where age is 25.

Can I use multiple conditions to filter?

Yes, you can use multiple conditions by passing an object with multiple key-value pairs. For example: where: { age: 25, status: 'active' }.

What about using operators like greater than or less than?

You can use Sequelize operators for that. For example, where: { age: { [Op.gt]: 18 } } will filter for ages greater than 18.

How do I include related models in my filter?

You can use the include option to filter based on related models. For example: Model.findAll({ include: [{ model: RelatedModel, where: { status: 'active' } }] }).