ORDERBY
| Specification | Value |
|---|---|
| Description | Specifies a column or expression on which the query result set is sorted. Used as a clause of SELECT. |
| Parameter 1 Name | attribute |
| Parameter 1 Type | any type |
| Parameter 2 Name | order (optional) // if not set, the default is ASC |
| Parameter 2 Type | const - ASC or DESC |
| Parameter 3 Name | inner clauses (optional) |
| Parameter 3 Type | expression |
| Return value | Ordered result set of a query by the specified column or expression. |
| Introduced in version | 2020 |
Note
Not all attributes support sorting by ORDERBY. You can check if the attribute supports ORDERBY in the "Supports Order By: True/False" property of the attribute. The information is available in the Attribute Details section in the model documentation of the entity. E.g. https://docs.erp.net/model/entities/Crm.Sales.SalesOrders.html#documentdate
Example: Select the last 5 Sales Order Lines sorted by Sales Order's document date .
10: SELECT REPO:Crm.Sales.SalesOrderLines EXP:20
20: TOP CONST:5 EXP:30
30: ORDERBY EXP:40 CONST:DESC EXP:50
40: GETOBJVALUE REF:SalesOrder ATTRIB:DocumentDate
50: WHERE ...