How to combine basic where clause and include where clause

[Julien Musat]

Hello,

Here is what I'm trying to do :

app.models.restaurant.findAll(

{

where: {id: restaurantIds}

},

{

include: [{

model: app.models.food_type, 

where: {id: 2} ,

through: {attributes: []}

}]

});

I have first where clause on restaurant, and a second where clause on food_type which is related with a Many to Many relation that works fine.

If I query each where clause separately it works. But when combined, the where clause in include is ignored

[Julien Musat]

Moreover, if I change I place include before where clause on restaurant, the where clause on restaurant is ignored

[Mick Hansen]

Ignored how?
There's really no case where `include.where` is ignored.

You might be looking for: https://github.com/sequelize/sequelize/issues/3095

--

Mick Hansen

@mhansendev
mhansen.io

[Julien Musat]

Actually, the whole include option is ignored when placed after the where clause on restaurant

[Julien Musat]

I've just found a workaround :

app.models.restaurant.findAll(

{

include: [{

model: app.models.food_type, 

where: ['restaurant.id IN(?) and food_types.id = ?', restaurantIds, 2],

through: {attributes: []}

}]

}

);