node.js - 我如何在 Sequelize 中做到这一点？

Question

SELECT client_name,mid_number,user_name,PASSWORD 
FROM automation_run_log 
WHERE LENGTH(schedule_status="FAILED") > 0 
GROUP BY client_name

我的代码:

automationRunLog.findAll({
    attributes : ["clientName","midNumber","userName","password"],
    where      : sequelize.where(sequelize.fn('length',      sequelize.col('schedule_status')),"FAILED"),
    group      : ['clientName']
    }).then(function (clientDtls) {
    console.log(clientDtls)
})

在 where 子句中我在哪里给出 $gt:0？

Answer 1

我没有时间尝试，但这应该有效:

automationRunLog.findAll({
  attributes : ["clientName","midNumber","userName","password"],
  where      : sequelize.where(sequelize.fn('length', 
               sequelize.col('schedule_status')),"FAILED", {$gt: 0}),
  group      : ['clientName']
}).then(function (clientDtls) {
  console.log(clientDtls)
})