Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface WhereExpression

Query Builders can implement this interface to support where expression

Hierarchy

  • WhereExpression

Implemented by

Index

Methods

andWhere

  • Adds new AND WHERE condition in the query builder. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Adds new AND WHERE condition in the query builder. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Adds new AND WHERE condition in the query builder. Additionally you can add parameters used in where expression.

    Parameters

    • subQuery: function
        • (qb: this): string
        • Parameters

          • qb: this

          Returns string

    • Optional parameters: ObjectLiteral

    Returns this

andWhereInIds

  • andWhereInIds(ids: any | any[]): this
  • Adds new AND WHERE with conditions for the given ids.

    Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]

    Parameters

    • ids: any | any[]

    Returns this

orWhere

orWhereInIds

  • orWhereInIds(ids: any | any[]): this
  • Adds new OR WHERE with conditions for the given ids.

    Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]

    Parameters

    • ids: any | any[]

    Returns this

where

  • Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.

    Parameters

    Returns this

  • Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.

    Parameters

    • subQuery: function
        • (qb: this): string
        • Parameters

          • qb: this

          Returns string

    • Optional parameters: ObjectLiteral

    Returns this

whereInIds

  • whereInIds(ids: any | any[]): this
  • Adds new AND WHERE with conditions for the given ids.

    Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]

    Parameters

    • ids: any | any[]

    Returns this

Generated using TypeDoc