How to sort by the result of multiple columns division with Sequelize.js?

Question

Here I want to sort by the result of multiple columns division, like:

ORDER BY col1 / col2 DESC

Or,

ORDER BY col2 / col3 / col4 ASC.

Is there some way to sort like this using sequelize.js ?

https://stackoverflow.com/questions/6913512/how-to-sort-an-array-of-objects-by-multiple-fields — Salman A, Dec 19 '17 at 09:30

score 3 · Accepted Answer · answered Dec 19 '17 at 11:39

3

For lastest Sequelize.js, I find out this way to solve the question:

 order: [
   [
     {
       raw: 'col1 / col2 DESC',
     },
   ],
 ],

answered Dec 19 '17 at 11:39

weichao.x

1 Answers1