.sort()Set the order in which retrieved records should be returned when executing a query instance.
.sort(sortClause)
| Argument | Type | Details | |
|---|---|---|---|
| 1 | sortClause | If specified as a string, this should be formatted as: an attribute name, followed by a space, followed by either ASC or DESC to indicate an ascending or descending sort (e.g. name ASC). If specified as an array, then each array item should be a dictionary with a single key representing the attribute to sort by, whose value is either ASC or DESC. The array syntax allows for sorting by multiple attributes, using the array order to establish precedence (e.g. [ { name: 'ASC' }, { age: 'DESC'} ]). |
To sort users named Jake by age, in ascending order:
var users = await User.find({ name: 'Jake'})
.sort('age ASC');
return res.json(users);
To sort users named Finn, first by age, then by when they joined:
var users = await User.find({ name: 'Finn'})
.sort([
{ age: 'ASC' },
{ createdAt: 'ASC' },
]);
return res.json(users);
The .find() method returns a chainable object if you don't supply a callback. This method can be chained to .find() to further filter your results.
If you notice something we've missed or could be improved on, please follow this link and submit a pull request to the sails repo. Once we merge it, the changes will be reflected on the website the next time it is deployed.