I am having trouble with server-side sorting using ORM Sequelize. By default, the sorting is supposed to be done by name in ascending order. However, when I try to change it to descending order on the client side, nothing happens despite seeing the request being displayed in the terminal.
Executing (default): SELECT count(*) AS "count" FROM "spr_turbodrills" AS "spr_turbodrills";
Executing (default): SELECT "turbodrill_id", "name", "spindle", "turbodrill_n", "createdAt", "updatedAt" FROM "spr_turbodrills" AS "spr_turbodrills" ORDER BY "spr_turbodrills"."name" ASC LIMIT 1 OFFSET 0;
It seems that the sorting based on the SQL query did not actually happen as intended.
Despite everything appearing fine on this end.
GET /api/directory/spr_turbodrills/all?order=desc&pageSize=1&page=1 200 7.805 ms - 163
Controller Method:
module.exports.getAllPaginate = async function (req, res) {
try {
const query = {
offset: +req.query.pageSize * ( +req.query.page - 1),
limit: +req.query.pageSize,
order: [
['name', 'ASC']
]
}
const spr_turbodrills = await SprTurbodrills.findAndCountAll(query)
res.status(200).json(spr_turbodrills)
} catch(e) {
errorHandler(res, e)
}
}