?
db.sortBy
Order a query by a column. Chain `reverse` for descending.
Query.sortBy(accessor) → Query<T[]>
Orders the query by the accessed column, ascending, compiling to SQL ORDER BY. Chain reverse for descending and take to cap the result. It sorts on your own columns or the automatic ones like created_at.
Parameters
accessor
(row) => Sortable
RequiredThe column to order by.
Sort a query
const recent = await Posts.sortBy((p) => p.created_at).reverse();