javascript - Order By (alias) then Order by second sequalize

Question

我正在使用 sequalize.js，我在使用订单语句时遇到问题，我想先按 if id 排序（如果我的 id 在该别名表中），然后再按另一个订单....

order = [['alias', 'id'], /*[this order statement already works]*/]
include = [    
      {
          model: model.aliasTable,
          as: 'alias'
      }
]
//['alias', 'id'] this is what is not working in my order statement

标签： javascriptnode.jsdatabasesequelize.jspsql

Answer 1

尝试order: [['alias', 'DESC'], ['id', 'DESC']]