Sequlize sorts by custom field

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"]
                                ]
                            },
                        }
                    ]
                },
            ]
        });

that"s fine
but I think sorting according to shop"s custom field distance is a problem

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

report Unknown column "user- > shop.distance" in" order clause"

how can I sort by shop"s custom field distance?

Sequelize node.js

Mar.28,2022

Brother, no solution

Previous: How to better understand closures

Next: How does this antd form use getFieldDecorator () instead of getFieldProps ()?

Sequelize field underlined to hump
how to convert field hump type and underscore type by adding, deleting, modifying and searching operation by Sequelize ...

Sequelize node.js

Mar.01,2021
How to solve the problem that the memory of sequelize connection cache is too high?
ask for help. The company s project is divided into libraries according to business. After establishing a connection using sequelize, the connection cache is saved in memory. When there are many sub-libraries, the memory occupation is too high, is there...

Koa.js sequelize node.js

Mar.10,2021
How to solve the problem of multi-table modification in nodejs sequelize framework?
< hr > how can this method be changed to sequelize syntax? Multiple table associations urgent. makeupUpdateAccountInfo: function (data) { var companyCode = "" if (data && data.companyCode) { companyCode = ...

Sequelize node.js mysql

Apr.02,2021
Can sequelize.query () native queries use the replacements parameter to prevent sql injection?
Can the sequelize.query () native query use the replacements parameter to prevent sql injection? sequelize.query( SELECT * FROM projects WHERE status = ? , { replacements: [ active ], type: sequelize.QueryTypes.SELECT } ).then(projects => { ...

Secure sql sequelize node.js

Jun.29,2021
How egg-sequelize connects 2 databases.
use strict ; module.exports = appInfo => { const config = {}; should change to your own config.keys = appInfo.name + _sequelize-example ; config.sequelize = { dialect: mssql , support: mysql, mariadb, postgres, mssql ...

Eggjs sequelize node.js

Jul.08,2021
Data Synchronize problem under High concurrency of mysql
at present, if you encounter such a problem of using mysql, first describe the scenario (some simplifications have been made to facilitate the answer): now there are two machines that use the same database account and access and operate a mysql addres...

Mysql sequelize node.js database database-design

Sep.23,2021
When using Sequelize to define the Model model, set the column data type to Sequelize.JSON to always report errors, and the database to ask for help from the bosses for mysql,?
problem description uses node.js s ORM framework Sequelize to operate the database, defines the model model through sequelize.define () , and then sets the data type of the column data field to DataType to Sequelize.JSON,. After setting it to sequ...

Mysql sequelize node.js

Oct.13,2021
An error occurred in the request after the node service was officially published
the koa + sequelize, used will leave new sequelize, as soon as it enters the project. It s normal locally, but it won t work online. It s always adjusted for the first time, and it will make mistakes later. Later, it will be changed to go to new seque...

Mysql sequelize node.js

Nov.12,2021
Sequlize update () returned data problem?
my requirement is to return the updated data after updating the data but sequlize only returns an array in update (), indicating the number of updates. has to check and return it once after the update. Is there a way for sequlize to return updated da...

Sequelize node.js

Jan.16,2022