sequelize子查询不生效

Question

    userOrganizationModel.hasMany(organizationModel, {
        foreignKey: 'organization_id'
    });
    // 此include未生效
    const include = [{
        model: organizationModel,
        required: false,
        where: {
            name: {
                $like: 'ext-%'
            }
        }
    }];

    await userOrganizationModel.findAll({
        include: include // 此include未生效
    })
    
    想实现的原始sql:
    // mysql原生语句select * from user_organization where organization_id in(select id from organization where name like 'ext-%')

Answer 1

include好像是嵌套预加载样,我猜是这样写,没有实践过,但是好像可以通过app.Sequelize.literal()直接在查询中写sql语句

userOrganizationModel.findAll({
    include: [ {
        model: organizationModel,
        as: 'Organizations',
        attributes: ['id'],
        where: { name: { $like: 'ext-%' }}
    } ],
    where: { organization_id: { $in: Organizations.map(o => o.id) } }
})