Scalar FunctionsDynamic / JSON Functions
array_sort_asc
Sort a dynamic array in ascending order.
An optional nulls_last
boolean (default true) controls whether null entries sort to the end
or the front.
Mixed-type arrays follow a canonical cross-family ordering: boolean/numeric values as one family (false < true < numeric), then strings, datetimes, timespans, arrays, and property bags. Exact cross-family ordering for rare mixes (e.g. datetime vs. string) diverges slightly from Microsoft Kusto.
Syntax
array_sort_asc(array, nulls_last)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
print array_sort_asc(dynamic([3, 1, 2]))| print_0 (dynamic) |
|---|
| [1,2,3] |