这样查询时,includ就嵌套了,结果就出错了:
orders.findAll({
attributes: ['id', 'code', 'status', 'createTime'],
where: {
personID: req.body.personID
},
include: [ {
as: 'address',
model: receiveAddress,
attributes: ['id', 'area', 'address']
}, {
model: orderDetail,
attributes: ['id', 'quantity'],
include: [{
model: goods,
attributes: ['id', 'desc', 'name', 'cover']
}]
}],
order: [
['createTime', 'DESC'],
],
offset: req.body.pageIndex * req.body.pageSize,
limit: req.body.pageSize
})
报错是错误的receiveAddressID字段,但这个字段是我的model定义的映射字段,不是数据库里的字段
//订单表的外键
receiveAddressID: {
type: Sequelize.STRING,
allowNull: false,
field: 'PerSon_Address_ID'
}
//关系定义
orders.belongsTo(receiveAddress, {
as: 'address',
foreignKey: 'receiveAddressID',
through: null
});


这个问题怎么解决呢?