squelize and sqlite concat two column and place conditional in where on that

user_18891284 0
Viewed 26
this.User.findAll({
  attributes: ['id', [sequelize.literal("firstname || 
        ' ' || lastname "),"
        fullName "],"
        fullName "],where:  {
          fullName: {
            [Op.like]: '%' + searchData + "%"
          }
        }
      })

//SQLITE_ERROR: no such column: fullName

sequelize.js node.js sqlite
1 Answers

Use the same literal in Sequelize.where to achieve your goal:

this.User.findAll({
  attributes: ['id', [sequelize.literal("firstname || 
        ' ' || lastname "),"
        fullName "],"
        fullName "],
  where: Sequelize.where(sequelize.literal("firstname || 
        ' ' || lastname "), Op.like, '%' + searchData + '%')
      })
user_13766180
Related