OINO TS
    Preparing search index...

    Class OINODbQueryFilter

    Class for recursively parsing of filters and printing them as SQL conditions. Supports three types of statements

    • comparison: (field)-lt|le|eq|ge|gt|like(value)
    • negation: -not(filter)
    • conjunction/disjunction: (filter)-and|or(filter) Supported conditions are comparisons (<, <=, =, >=, >) and substring match (LIKE).

    Hierarchy

    • unknown
      • OINODbQueryFilter
    Index

    Constructors

    constructor

    Methods

    buildSql printSql

    Constructors

    Methods

    • Build filter as SQL condition based on the datamodel of the API, appending any values to the given statement.

      Column names are validated against the datamodel and values are added to statement (bound as parameters, or inlined as escaped literals when the statement is in legacy mode).

      Parameters

      • filter: OINOQueryFilter

        filter to build

      • dataModel: OINODbDataModel

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

      • statement: OINODbSqlStatement

        statement being assembled (collects bind values / provides placeholders)

      Returns string

    • Print filter as an inline (non-parameterized) SQL condition string.

      Parameters

      • filter: OINOQueryFilter

        filter to print

      • dataModel: OINODbDataModel

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

      Returns string

      Prefer buildSql with a parameterized OINODbSqlStatement.

    Settings

    Member Visibility

    On This Page

    Constructors
    Methods