Class OINODbSqlOrder

Class for ordering select results on a number of columns.

Constructors

constructor

Methods

isEmpty toSql parse

Constructors

constructor

  • new OINODbSqlOrder(column_or_array, descending_or_array): OINODbSqlOrder

  • Constructor for OINODbSqlOrder.

    Parameters

    • column_or_array: string | string[]

      single or array of columns to order on

    • descending_or_array: boolean | boolean[]

      single or array of booleans if ordes is descending

    Returns OINODbSqlOrder

Methods

isEmpty

toSql

  • toSql(dataModel): string

  • Print order as SQL condition based on the datamodel of the API.

    Parameters

    • dataModel: OINODbDataModel

      data model (and database) to use for formatting of values

    Returns string

Static parse

  • parse(orderString): OINODbSqlOrder

  • Constructor for OINODbSqlOrder as parser of http parameter.

    Supports comma separated list of column orders formatted as :

    • column - order by column in ascending order
    • column ASC|DESC - order by single either ascending or descending order
    • column+|- - order by single either ascending or descending order

    Parameters

    • orderString: string

      string representation of order from HTTP-request

    Returns OINODbSqlOrder

Settings

Member Visibility

Theme

On This Page

constructorisEmptytoSqlparse