How to search over multiple fields using sequelize in node js?

Question

I am developing a simple blog which includes users and posts. Users and Posts have different fields. I want to search for a keyword using one function. To achieve it, I should be able to search using sequelize from multiple columns. For more information, I provide the contents of models as a dictionary below.

Users = {
    'firstName': Sequelize.STRING,
    'email': Sequelize.STRING,
    'password': Sequelize.STRING,
}

Posts = {
    'title': Sequelize.STRING,
    'content': Sequelize.TEXT,
}

What I want to achieve:

model.findAll({
    where: {
        *: {
        [Op.iLike]: "%searchingkeyword%"
        }
})
// Imagine model is passed to function and it can either be Users or Posts

*: means all fields

Question: How to search over multiple fields withouth specifically writing them?

Madiyor · Accepted Answer · 2020-06-26 17:46:40Z

4

I found the answer which I do not really know if it is ok solution. (I am coming from Python background!)

Dependencies:

lodash - I used to filter out some keys sequelize - I have used Op from sequelize

const _ = require("lodash");
const { Op } = require("sequelize");

...

const value = {
    [Op.iLike]: "%" + req.query.search + "%"
}

...
const fields = Object.keys(
    _.omit(model.rawAttributes, [
        "password",
        "id",
        "createdAt",
        "updatedAt",
    ])
);
const filters = {};
fields.forEach((item) => (filters[item] = value));

const result = await model.findAndCountAll({
    where: {
         [Op.or]: filters
    }
});
...

edited Jun 26, 2020 at 17:46

answered Jun 26, 2020 at 17:15

Madiyor

8111 gold badge11 silver badges25 bronze badges

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

2 Comments

Mark Watney Over a year ago

That is a very clever solution

conor909 Over a year ago

What is I wanted to match say exact id, AND where any filter matches any field?

Collectives™ on Stack Overflow

How to search over multiple fields using sequelize in node js?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related