MarkLogic Server 11.0 Product Documentationop:desc
op:desc( $column as item() ) as map:map
Summary
This function sorts the rows by the values of the specified column in descending order. The results are used by the op:order-by function.
| Parameters | |
|---|---|
| $column | The column by which order the output. |
Example
xquery version "1.0-ml";
import module namespace op="http://marklogic.com/optic"
at "/MarkLogic/optic.xqy";
let $employees := op:from-view("main", "employees")
let $expenses := op:from-view("main", "expenses")
let $totalexpenses := op:col("totalexpenses")
return $employees
=> op:join-inner($expenses, op:on(
op:view-col("employees", "EmployeeID"),
op:view-col("expenses", "EmployeeID")))
=> op:group-by(op:view-col("employees", "EmployeeID"),
("FirstName", "LastName",
op:view-col("expenses", "Category"),
op:sum($totalexpenses,
op:view-col("expenses", "Amount"))))
=> op:order-by(op:desc(op:view-col("employees", "EmployeeID")))
=> op:result()