我正在sequilize中使用左外部联接，我想在profilePicture:'public/uploads/default/default-Male.png‘和profilePicture:'public/uploads/default/default-Female.png’之间使用or
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 }
]
});
在此过程中，iam获取输出
`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')
只需在op.not内使用op.or，如下所示:
where: { [Op.not]:
{ [Or.or]: [{ profilePicture : 'public/uploads/default/default-male.png'}, { profilePicture :'public/uploads/default/default-female.png' }
]
}},
required: false
}
