sequlize 根据自定义字段排序

Question

let pets=await ctx.model.Pet.findAndCount({
            offset:offset,
            limit:query.limit,
            order: [
                [ctx.model.User,ctx.model.Shop,'userId','ASC'],
                ['createdAt', 'DESC']
            ],
            include:[
                {
                    model:ctx.model.User,
                    as:'user',
                    include:[
                        {
                            model:ctx.model.Shop,
                            attributes:{
                                include:[
                                    // [ctx.model.fn('max',ctx.model.Sequelize.col('latitude')),'distance']
                                    [ctx.model.fn('apart',ctx.model.Sequelize.col('latitude'),ctx.model.Sequelize.col('longitude'),2.0,2.0),'distance']
                                ]
                            },
                        }
                    ]
                },
            ]
        });

这样是可以的
但是我想排序根据shop的自定义字段distance来排序就有问题了

 order: [
                [ctx.model.User,ctx.model.Shop,'distance','ASC'],
                ['createdAt', 'DESC']
            ],

报Unknown column 'user->shop.distance' in 'order clause'

要怎样才能根据shop的自定义字段distance来排序呢？

Answer 1

老哥，解决了没有