orderBy
method seems simple but has a lot of depth depending on the type of arguments you pass in.orderBy
multiple times appends to the order list.false
"asc"
"asc"
or "desc"
.orderBy
multiple times will append to the order list.true
false
"asc"
"asc"
or "desc"
. This value will be used as the default value for all entries in the column list that fail to specify a direction for a specific column.true
false
"asc"
"asc"
or "desc"
. This value will be used as the default value for all entries in the column array that fail to specify a direction for a specific column.true
{ column = "favorite_color", direction = "desc" }
).false
"asc"
"asc"
or "desc"
. This value will be used as the default value for all entries in the column array that fail to specify a direction for a specific column.true
Expression
can be passed as well. An array can be passed with any combination of simple values, array, struct, or list for each entry in the array (an example with all possible value styles: column = [ "last_name", [ "age", "desc" ], { column = "favorite_color", direction = "desc" }, "height|desc" ];. The column argument can also just accept a comman delimited list with a pipe ( | ) as the secondary delimiter denoting the direction of the order by. The pipe delimiter is also used when parsing the column argument when it is passed as an array and the entry in the array is a pipe delimited string.false
"asc"
true
false
[]
?
) used in the expression.​
false
"asc"
"asc"
or "desc"
.