Skip to main content
Version: 4.5

Interface: JoinClause#

knex.Knex.JoinClause

Methods#

andOn#

andOn(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1135

andOn(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1136

andOn(columns: { [key: string]: string | Raw; }): JoinClause

Parameters:#

NameType
columnsobject

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1137

andOn(column1: string, column2: string): JoinClause

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1138

andOn(column1: string, raw: Raw<any>): JoinClause

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1139

andOn(column1: string, operator: string, column2: string | Raw<any>): JoinClause

Parameters:#

NameType
column1string
operatorstring
column2string | Raw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1140


andOnBetween#

andOnBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1166


andOnExists#

andOnExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1160


andOnIn#

andOnIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1148


andOnNotBetween#

andOnNotBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1169


andOnNotExists#

andOnNotExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1163


andOnNotIn#

andOnNotIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1151


andOnNotNull#

andOnNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1157


andOnNull#

andOnNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1154


on#

on(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1129

on(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1130

on(columns: { [key: string]: string | Raw; }): JoinClause

Parameters:#

NameType
columnsobject

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1131

on(column1: string, column2: string): JoinClause

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1132

on(column1: string, raw: Raw<any>): JoinClause

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1133

on(column1: string, operator: string, column2: string | Raw<any>): JoinClause

Parameters:#

NameType
column1string
operatorstring
column2string | Raw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1134


onBetween#

onBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1165


onExists#

onExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1159


onIn#

onIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1147


onNotBetween#

onNotBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1168


onNotExists#

onNotExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1162


onNotIn#

onNotIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1150


onNotNull#

onNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1156


onNull#

onNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1153


orOn#

orOn(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1141

orOn(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1142

orOn(columns: { [key: string]: string | Raw; }): JoinClause

Parameters:#

NameType
columnsobject

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1143

orOn(column1: string, column2: string): JoinClause

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1144

orOn(column1: string, raw: Raw<any>): JoinClause

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1145

orOn(column1: string, operator: string, column2: string | Raw<any>): JoinClause

Parameters:#

NameType
column1string
operatorstring
column2string | Raw<any>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1146


orOnBetween#

orOnBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1167


orOnExists#

orOnExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1161


orOnIn#

orOnIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1149


orOnNotBetween#

orOnNotBetween(column1: string, range: readonly [any, any]): JoinClause

Parameters:#

NameType
column1string
rangereadonly [any, any]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1170


orOnNotExists#

orOnNotExists(callback: QueryCallback<any, unknown[]>): JoinClause

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1164


orOnNotIn#

orOnNotIn(column1: string, values: readonly any[]): JoinClause

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1152


orOnNotNull#

orOnNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1158


orOnNull#

orOnNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1155


type#

type(type: string): JoinClause

Parameters:#

NameType
typestring

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1174


using#

using(column: string | readonly string[] | Raw<any> | { [key: string]: string | Raw; }): JoinClause

Parameters:#

NameType
columnstring | readonly string[] | Raw<any> | { [key: string]: string | Raw; }

Returns: JoinClause

Defined in: node_modules/knex/types/index.d.ts:1171

Last updated on by Martin Adámek