YZ
it doesn't work
Show code
Size: a a a
2019 September 19
FP
beacuse the WHERE is on the other table
FP
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
required: false,
where: where
}]
})
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
required: false,
where: where
}]
})
YZ
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
required: false,
where: where
}]
})
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
required: false,
where: where
}]
})
Move where to up
YZ
Include...,
Where
Where
YZ
Where should be outside
FP
ok, but the GymUser doesn't have the gymUserId field...
YZ
You need write - gymAdmin.userid: null
FP
Unknown column 'gymUser.gymUserId' in 'where clause'\nsql: SELECT
gymUser.idYZ
Show changed code
FP
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})
YZ
Yes, you need to change where condition
FP
Ok, how I've to change?
YZ
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})
Like here: https://stackoverflow.com/a/36287978
FP
ok, I'll try
FP
mmm, no luck because the foreign key (gymUserId) is on gymAdmin table
YZ
Show code
FP
let where = {
'$gymAdmin.gymUserId$' : 100
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})
'$gymAdmin.gymUserId$' : 100
}
return GymUser.findAll({
where: where,
include: [{
model: GymAdmin,
required: false
}]
})