Skip to main content
Version: 5.8

IQueryBuilder <T>

Index

Properties

optional_fields

_fields?: Field<T>[]

readonlyalias

alias: string

optionalreadonlytype

type?: QueryType

Methods

addSelect

andWhere

count

  • count(field?: string | string[], distinct?: boolean): IQueryBuilder<T>
  • Parameters

    • optionalfield: string | string[]
    • optionaldistinct: boolean

    Returns IQueryBuilder<T>

delete

getAliasForJoinPath

  • getAliasForJoinPath(path: string): undefined | string
  • Parameters

    • path: string

    Returns undefined | string

getNextAlias

  • getNextAlias(entityName?: string): string
  • Parameters

    • optionalentityName: string

    Returns string

groupBy

  • groupBy(fields: string | keyof T | (string | keyof T)[]): IQueryBuilder<T>
  • Parameters

    • fields: string | keyof T | (string | keyof T)[]

    Returns IQueryBuilder<T>

having

innerJoinAndSelect

insert

join

  • join(field: string, alias: string, cond?: QBFilterQuery, type?: leftJoin | innerJoin | pivotJoin, path?: string): IQueryBuilder<T>
  • Parameters

    • field: string
    • alias: string
    • optionalcond: QBFilterQuery
    • optionaltype: leftJoin | innerJoin | pivotJoin
    • optionalpath: string

    Returns IQueryBuilder<T>

joinAndSelect

leftJoin

leftJoinAndSelect

orWhere

orderBy

raw

  • raw(field: string): any
  • Parameters

    • field: string

    Returns any

select

truncate

update

where

withSubQuery

  • withSubQuery(subQuery: QueryBuilder<any, any>, alias: string): IQueryBuilder<T>
  • Parameters

    • subQuery: QueryBuilder<any, any>
    • alias: string

    Returns IQueryBuilder<T>