Sequelize 爬坑【1】or aggregate order

Sequelize

or 查询正确用法

where: {
    [Op.or]: [
        {
            name: { [Op.substring]: where.rules[i].value },
        },
        {
            mobile: { [Op.substring]: where.rules[i].value },
        }
    ]
}

aggregate 合并查询

let user = await model.PublicUser.aggregate(
    'id',
    'array_agg',
    {
        where: {
            [Op.or]: [
                {
                    name: { [Op.substring]: where.rules[i].value },
                },
                {
                    mobile: { [Op.substring]: where.rules[i].value },
                }
            ],
            deleted: false
        }
    })

findAndCountAll 查找并统计

 let query_result = await model.PlateNoInfo.findAndCountAll({
      where: {
       deleted: false
 });

order 排序

 let query_result = await model.PlateNoInfo.findAndCountAll({
     order: [['total_unpaid_fee', 'DESC']]
 });