node.js - 我在 sequelize 中使用 Op.not 并且我想在相同的字段之间使用或

Question

我在 sequilize 中使用 LEFT OUTER JOIN 并且我想使用或在 profilePicture 之间使用:'public/uploads/default/default-male.png' 和 profilePicture :'public/uploads/default/default-female.png'

return models.Users.findAll({
        where: {userType:'engineer'},
        include: [
            { model: models.CandidateDetails, as: "CandidateDetails",
            where: { [Op.not]: 
                [{ profilePicture : 'public/uploads/default/default-male.png'}, {profilePicture :'public/uploads/default/default-female.png'}
                                ]}, required: false }
            ]
      });

在这个我得到输出

`CandidateDetails`.`user_id` AND NOT (`CandidateDetails`.`profile_picture` = 'public/uploads/default/default-male.png' AND `CandidateDetails`.`profile_picture` LIKE 'public/uploads/default/default-female.png')

Answer 1

只需在 Op.or 中使用 Op.not ，如下所示:

where: { [Op.not]: 
    { [Or.or]: [{ profilePicture : 'public/uploads/default/default-male.png'}, { profilePicture :'public/uploads/default/default-female.png' }
                                ]
    }},
    required: false
}