Skip to content

WhenBuilder

Defined in: functions/conditional.ts:23

new WhenBuilder(branches): WhenBuilder;

Defined in: functions/conditional.ts:27

ParameterType
branches{ condition: Column; value: Column; }[]

WhenBuilder

otherwise(value): Column;

Defined in: functions/conditional.ts:35

ParameterType
valueColumn

Column


toColumn(): Column;

Defined in: functions/conditional.ts:45

Convert to Column without an otherwise clause (NULL for non-matching rows).

Column


when(condition, value): WhenBuilder;

Defined in: functions/conditional.ts:31

ParameterType
conditionColumn
valueColumn

WhenBuilder