所以我有这个查询,这将返回多个字段,所以我所做的是,我想总结某个字段,并根据新的别名对其进行排序
const salesOrders = await SalesOrders.findAndCountAll({
attributes: ['grandTotal', 'refNo', 'userId', 'createdAt', 'deletedAt', [Sequelize.literal('SUM(grand_total)'), 'sumTotal']],
limit: _.toInteger(limit || getLimitOffset(req).limit),
offset: _.toInteger(offset || getLimitOffset(req).offset),
separate: true,
group: ['userId'],
order: ['sumTotal', 'DESC'],
where: {
userId: {
[Sequelize.Op.in]: userIds
},
...transactionFilter
},
但是它说它不识别“sumTotal”,它给了我这个错误:
sqlMessage: "Unknown column 'SalesOrders.sumTotal' in 'order clause'",
是否有一种方法来识别我的续集新申报的别名?
1条答案
按热度按时间rm5edbpk1#
顺序语法是两级数组。你应该改成