Skip to main content
Version: 4.4

Interface: JoinClause#

knex.Knex.JoinClause

Hierarchy#

  • JoinClause

Methods#

andOn#

andOn(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

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

andOn(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

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

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

Parameters:#

NameType
columns{ [key: string]: string | Raw; }

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

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

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:1134


andOnBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


andOnExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


andOnIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


andOnNotBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


andOnNotExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


andOnNotIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


andOnNotNull#

andOnNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


andOnNull#

andOnNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


on#

on(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

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

on(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

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

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

Parameters:#

NameType
columns{ [key: string]: string | Raw; }

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

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

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:1128


onBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


onExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


onIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


onNotBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


onNotExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


onNotIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


onNotNull#

onNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


onNull#

onNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


orOn#

orOn(raw: Raw<any>): JoinClause

Parameters:#

NameType
rawRaw<any>

Returns: JoinClause

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

orOn(callback: JoinCallback): JoinClause

Parameters:#

NameType
callbackJoinCallback

Returns: JoinClause

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

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

Parameters:#

NameType
columns{ [key: string]: string | Raw; }

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
column2string

Returns: JoinClause

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

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

Parameters:#

NameType
column1string
rawRaw<any>

Returns: JoinClause

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

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:1140


orOnBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


orOnExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


orOnIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


orOnNotBetween#

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

Parameters:#

NameType
column1string
rangereadonly any[]

Returns: JoinClause

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


orOnNotExists#

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

Parameters:#

NameType
callbackQueryCallback<any, unknown[]>

Returns: JoinClause

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


orOnNotIn#

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

Parameters:#

NameType
column1string
valuesreadonly any[]

Returns: JoinClause

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


orOnNotNull#

orOnNotNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


orOnNull#

orOnNull(column1: string): JoinClause

Parameters:#

NameType
column1string

Returns: JoinClause

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


type#

type(type: string): JoinClause

Parameters:#

NameType
typestring

Returns: JoinClause

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


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:1165

Last updated on by renovate[bot]