By Vishal Basumatary in javascript — Mar 24, 2023

sequelize order multiple

Sequelize Order Multiple

If you want to order data in a specific way using Sequelize, you can use the order option. The order option takes an array of arrays or objects where the first element is the column name and the second element is the sorting order.

Example:


    const users = await User.findAll({
      order: [['createdAt', 'DESC'], ['name', 'ASC']]
    });

In the example above, we are ordering the data by the createdAt column in descending order and then by the name column in ascending order.

Another way:

You can also use an object instead of an array to specify the column name and sorting order.

Example:


    const users = await User.findAll({
      order: { createdAt: 'DESC', name: 'ASC' }
    });

The result of both examples will be the same. It's up to you which syntax you prefer to use.