.sort()
Set the order in which retrieved records should be returned when executing a query instance.
.sort(sortClause)
Usage
| 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'} ]). |
Example
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);
Notes
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.
For a better experience on sailsjs.com, update your browser.
Reference
- Application
- Blueprint API
- Command-line interface
-
Configuration
- sails.config.*
- sails.config.blueprints
- sails.config.bootstrap()
- sails.config.custom
- sails.config.datastores
- sails.config.globals
- sails.config.http
- sails.config.i18n
- sails.config.log
- sails.config.models
- sails.config.policies
- sails.config.routes
- sails.config.security
- sails.config.session
- sails.config.sockets
- sails.config.views
-
Request (`req`)
- req._startTime
- req.body
- req.cookies
- req.fresh
- req.headers
- req.hostname
- req.ip
- req.ips
- req.isSocket
- req.method
- req.options
- req.originalUrl
- req.params
- req.path
- req.protocol
- req.query
- req.secure
- req.signedCookies
- req.socket
- req.subdomains
- req.url
- req.wantsJSON
- req.xhr
- req.accepts()
- req.acceptsCharsets()
- req.acceptsLanguages()
- req.allParams()
- req.file()
- req.get()
- req.is()
- req.param()
- req.setLocale()
- req.setTimeout()
- req.host
- Response (`res`)
- Waterline (ORM)
- WebSockets
Built with Love
The Sails framework is built by a web & mobile shop in Austin, TX, with the help of our contributors. We created Sails in 2012 to assist us on Node.js projects. Naturally we open-sourced it. We hope it makes your life a little bit easier!
© 2012-2023 The Sails Company.
The Sails framework is free and open-source under the MIT License.
Illustrations by Edamame.