order

Any query can be ordered. order accepts either a string (the name of a column), and sorts ascending, or a column => direction object. In the object notation, columns that appear earlier in the object take prescendence over subsequent columns. Calling column(null) removes any previously applied ordering.

// sort by `id`, ascending
await User.order('id').all()

// sort by `name`, ascending
await User.order({ name: 'asc' }).all()

// sort by `targetRating`, descending
await User.order({ targetRating: 'desc' }).all()

// sort by `name`, ascending; for records with identical names, sort by email, descending
await User.order({ name: 'asc', email: 'desc' }).all()

// unordered
await User.order('email').order(null).all()