Use model attribute as parameter on sequelize operator

Question

I am using sequelize v6 on my nodejs/express application. I am struggling to use an attribute of my model in the where clause of my findAll query.

What I want to achieve in SQL:

SELECT field1, field2, field3 FROM myTable
WHERE field2 != field3

what i have in my javascript:

const resultArray = myTable.findAll({
     attributes: [
         "field1",
         "field2",
         "field3",],
     where: {
        field2: { [Op.ne]: {field3}},
     })

What I am after is the right context to reference field3 in the [Op.ne] parameter.

Anatoly · Accepted Answer · 2022-06-16 19:27:19Z

1

Just use Sequelize.col to indicate a reference to a column for Sequelize:

const resultArray = myTable.findAll({
     attributes: [
         "field1",
         "field2",
         "field3",],
     where: {
        field2: { [Op.ne]: Sequelize.col('field3') },
     })

answered Jun 16, 2022 at 19:27

Anatoly

23.2k3 gold badges33 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Use model attribute as parameter on sequelize operator

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