To retrieve rows using Sequelize that have at least one many-to-many item, use the include
property in your query. The include
property allows you to specify related models to include in your result set.
Assuming you have a many-to-many association between two models ModelA
and ModelB
through a junction table ModelA_ModelB
, you can use the following code to retrieve all ModelA
instances that have at least one associated ModelB
instance:
ModelA.findAll({
include: [
{
model: ModelB,
through: { model: ModelA_ModelB }
}
]
})
This will generate a SQL query that joins the three tables and returns only the ModelA
instances that have at least one associated ModelB
instance. The through
property is used to specify the junction table for the many-to-many association.
Asked: 2022-11-22 11:00:00 +0000
Seen: 9 times
Last updated: Jun 17 '22