Show / Hide Table of Contents

    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 ...
    
    • Improve this Doc
    Back to top Generated by DocFX