| ... | ... | @@ -217,14 +217,9 @@ Ordering can be defined by the "order_by" attribute. |
|
|
|
|["colA", {-asc => "colB"}] | ORDER BY colA, colB ASC|
|
|
|
|
|{ "-asc" => ["colA","colB"] } | ORDER BY colA ASC, colB ASC|
|
|
|
|
|[ "FUNC(colA,?)", "bla" ] | ORDER BY FUNC(colA, ?) /* with "bla bound to ? */|
|
|
|
|
|<code>[ <br>{ "-asc" => "colA" },<br>{ "-desc" => ["colB"] },<br>{ "-asc" => ["colC","colD"] },<br>[ "FUNC(colF, ?)", "bla" ],<br>] </code> |
|
|
|
|
|[ <br>{ "-asc" => "colA" },<br>{ "-desc" => ["colB"] },<br>{ "-asc" => ["colC","colD"] },<br>[ "FUNC(colF, ?)", "bla" ],<br>] | ORDER BY, colA ASC,<br>colB DESC,<br>colC ASC, colD ASC,<br>FUNC(colF, ?) /* with "bla bound to ? */ |
|
|
|
|
|
|
|
|
|
|
|
|
```ORDER BY, colA ASC,
|
|
|
|
colB DESC,
|
|
|
|
colC ASC, colD ASC,
|
|
|
|
FUNC(colF, ?) /* with "bla bound to ? */```
|
|
|
|
|
|
|
|
The API also supports [similarity](/API/Queries/Query-Search-Options#similarity) for sorting.
|
|
|
|
|
|
|
|
Any column from a joined/prefetched table or a column selected with ["select"](#select-as) can be used.
|
| ... | ... | |