View Source Ash.Sort (ash v2.18.2)
Utilities and types for sorting.
Important
Keyset pagination cannot currently be used in conjunction with aggregate and calculation sorting. Combining them will result in an error on the query.
Summary
Functions
Builds an expression to be used in a sort statement.
A utility for parsing sorts provided from external input. Only allows sorting on public attributes and aggregates.
Same as parse_input/2
except raises any errors
Reverses an Ash sort statement.
A utility for sorting a list of records at runtime.
Types
@type sort_item() :: atom() | {atom(), sort_order()} | %Ash.Query.Calculation{ calc_name: term(), constraints: term(), context: term(), filterable?: term(), load: term(), module: term(), name: term(), opts: term(), required_loads: term(), select: term(), sequence: term(), type: term() } | {%Ash.Query.Calculation{ calc_name: term(), constraints: term(), context: term(), filterable?: term(), load: term(), module: term(), name: term(), opts: term(), required_loads: term(), select: term(), sequence: term(), type: term() }, sort_order()} | {atom(), {sort_order(), Keyword.t() | map()}}
@type sort_order() ::
:asc
| :desc
| :asc_nils_first
| :asc_nils_last
| :desc_nils_first
| :desc_nils_last
Functions
@spec expr_sort(Ash.Expr.t(), Ash.Type.t() | nil) :: Ash.Expr.t()
Builds an expression to be used in a sort statement.
For example:
Ash.Query.sort(Ash.Sort.expr_sort(author.full_name))
Ash.Query.sort([{Ash.Sort.expr_sort(author.full_name), :desc_nils_first}])
@spec parse_input( Ash.Resource.t(), String.t() | [atom() | String.t() | {atom(), sort_order()} | [String.t()]] | nil, nil | (String.t() -> nil | atom() | {atom(), map()}) ) :: {:ok, t()} | {:error, term()}
A utility for parsing sorts provided from external input. Only allows sorting on public attributes and aggregates.
The supported formats are:
Sort Strings
A comma separated list of fields to sort on, each with an optional prefix.
The prefixes are:
- "+" - Same as no prefix. Sorts
:asc
. - "++" - Sorts
:asc_nils_first
- "-" - Sorts
:desc
- "--" - Sorts
:desc_nils_last
For example
"foo,-bar,++baz,--buz"
A list of sort strings
Same prefix rules as above, but provided as a list.
For example:
["foo", "-bar", "++baz", "--buz"]
Handling specific values
A handler function may be provided that takes a string, and returns the relevant sort It won't be given any prefixes, only the field. This allows for things like parsing the calculation values out of the sort, or setting calculation values if they are not included in the sort string.
To return calculation parameters, return {:field, %{param: :value}}
. This will end up as something
like {:field, {:desc, %{param: :value}}}
, with the corresponding sort order.
This handler function will only be called if you pass in a string or list of strings for the sort.
Atoms will be assumed to have already been handled. The handler should return nil
if it is not handling
the given field.
Same as parse_input/2
except raises any errors
See parse_input/2
for more.
Reverses an Ash sort statement.
A utility for sorting a list of records at runtime.
For example:
Ash.Sort.runtime_sort([record1, record2, record3], name: :asc, type: :desc_nils_last)
Keep in mind that it is unrealistic to expect this runtime sort to always
be exactly the same as a sort that may have been applied by your data layer.
This is especially true for strings. For example, Postgres
strings have a
collation that affects their sorting, making it unpredictable from the perspective
of a tool using the database: https://www.postgresql.org/docs/current/collation.html