sequelize findAll sort order in nodejs

Question

I'm trying to output all object list from database with sequelize as follow and want to get data are sorted out as I added id in where clause.

exports.getStaticCompanies = function () {     return Company.findAll({         where: {             id: [46128, 2865, 49569,  1488,   45600,   61991,  1418,  61919,   53326,   61680]         },         attributes: ['id', 'logo_version', 'logo_content_type', 'name', 'updated_at']     }); }; 

But the problem is after rendering, all data are sorted out as follow.

46128, 53326, 2865, 1488, 45600, 61680, 49569, 1418, .... 

As I found, it's neither sorted by id nor name. Please help me how to solve it.

Answer 1

In sequelize you can easily add order by clauses.

exports.getStaticCompanies = function () {     return Company.findAll({         where: {             id: [46128, 2865, 49569,  1488,   45600,   61991,  1418,  61919,   53326,   61680]         },          // Add order conditions here....         order: [             ['id', 'DESC'],             ['name', 'ASC'],         ],         attributes: ['id', 'logo_version', 'logo_content_type', 'name', 'updated_at']     }); }; 

See how I've added the order array of objects?

order: [       ['COLUMN_NAME_EXAMPLE', 'ASC'], // Sorts by COLUMN_NAME_EXAMPLE in ascending order ], 

Edit:

You might have to order the objects once they've been recieved inside the .then() promise. Checkout this question about ordering an array of objects based on a custom order:

How do I sort an array of objects based on the ordering of another array?

Answer 2

If you want to sort data either in Ascending or Descending order based on particular column, using sequlize js, use the order method of sequlize as follows

// Will order the specified column by descending order order: sequelize.literal('column_name order') e.g. order: sequelize.literal('timestamp DESC')