CaseWhen

class CaseWhen<T>(val value: Expression<*>?)

Represents an SQL function that allows the comparison of value to chained conditional clauses.

If value is not provided, each chained conditional will be evaluated independently.

Constructors

constructor(value: Expression<*>?)

The boolean conditions to check and their resulting expressions if the condition is met.

The value that is compared against every conditional expression.

Adds an expression that will be used as the function result if all cases evaluate to false.

Adds a conditional expression with a result if the expression evaluates to true.