Sequelize associate multiple condition in a join

927 views
Skip to first unread message

Daniel Infante

unread,
May 5, 2016, 6:25:15 PM5/5/16
to Sequelize
Hello everywhere!

How do I make a join with multiple conditions?


Example:

************
Model1
Model2
***********

Model1.belongsTo(Model2);


Model1.findAll({
      attributes: ['id'],
      include: [{
        model: Model2
        where: {
           number: Model1.number =>>>>>>>>>>>>>>>>>> ¿:c?
        }
      }],
      where: {
        state: true
      }
})



I want this:

Select id From Model1 inner join Model2
On Model1.id = Model2.id
AND Model1.number = Model2.number



:c



Help me, please!

thank you!

Mick Hansen

unread,
May 6, 2016, 9:58:02 AM5/6/16
to Daniel Infante, Sequelize
include.where = {number: {$col: 'Model1.number'}}
--
Mick Hansen
@mhansendev
mhansen.io
Reply all
Reply to author
Forward
0 new messages