Kysoql
ReferenceAPI referenceInterfaces

ExpressionBuilder

Generated API reference for ExpressionBuilder in @kysoql/core.

@kysoql/core / ExpressionBuilder

Expression helper passed to typed WHERE callbacks.

Type Parameters

Type ParameterDefault type
DB-
TB extends keyof DB-
AllowSemiJoin extends booleantrue

Call Signature

ExpressionBuilder<Output, Sortable>(
   lhs,
   op,
   rhs
): ExpressionWrapper<DB, TB, false>;

Builds a typed WHERE comparison from the supplied left operand, operator, and right operand.

Type Parameters

Type Parameter
Output
Sortable extends boolean

Parameters

ParameterType
lhsDistanceFunctionExpression<Output, true, Sortable>
opDistanceComparisonOperator
rhsnumber

Returns

ExpressionWrapper<DB, TB, false>

Call Signature

ExpressionBuilder<Output, Value, AllowedOperator, Operator, Identity, Right>(
   lhs,
   op,
   rhs
): ExpressionWrapper<DB, TB, false>;

Builds a typed WHERE comparison from the supplied left operand, operator, and right operand.

Type Parameters

Type Parameter
Output
Value
AllowedOperator extends ComparisonOperator
Operator extends ComparisonOperator
Identity extends string
Right

Parameters

ParameterType
lhsDateFunctionExpression<Output, Value, AllowedOperator, Identity>
opOperator
rhsRight

Returns

ExpressionWrapper<DB, TB, false>

Call Signature

ExpressionBuilder<Reference, Operator, Right>(
   lhs,
   op,
   rhs
): ExpressionWrapper<DB, TB, false>;

Builds a typed WHERE comparison from the supplied left operand, operator, and right operand.

Type Parameters

Type Parameter
Reference extends string
Operator extends "=" | "!=" | "like"
Right extends string | SoqlLikeLiteral | null

Parameters

ParameterType
lhsToLabelFilterFunctionExpression<Reference>
opOperator
rhsRight

Returns

ExpressionWrapper<DB, TB, false>

Call Signature

ExpressionBuilder<Value, Operator>(
   lhs,
   op,
   rhs
): ExpressionWrapper<DB, TB, false>;

Builds a typed WHERE comparison from the supplied left operand, operator, and right operand.

Type Parameters

Type Parameter
Value
Operator extends FormulaFilterComparisonOperator

Parameters

ParameterType
lhsFormulaFilterFunctionExpression<Value>
opOperator
rhsValue

Returns

ExpressionWrapper<DB, TB, false>

Call Signature

ExpressionBuilder<RE, OP, RHS>(
   lhs,
   op,
   rhs
): ExpressionWrapper<DB, TB, SemiJoinFlag<RHS>>;

Builds a typed WHERE comparison from the supplied left operand, operator, and right operand.

Type Parameters

Type Parameter
RE extends string
OP extends | "=" | "!=" | OrderedComparisonOperator | "in" | "not in" | MultiSelectComparisonOperator | "like"
RHS

Parameters

ParameterType
lhsRE & FilterableFieldName<DB, TB, RE>
opOP
rhsRHS

Returns

ExpressionWrapper<DB, TB, SemiJoinFlag<RHS>>

Methods

and()

and<Expressions>(expressions): ExpressionWrapper<DB, TB, CombinedSemiJoinFlag<Expressions>>;

Combines two or more expressions with boolean AND.

Type Parameters

Type Parameter
Expressions extends readonly [ExpressionWrapper<DB, TB, boolean>, ExpressionWrapper<DB, TB, boolean>, ExpressionWrapper<DB, TB, boolean>]

Parameters

ParameterType
expressionsExpressions

Returns

ExpressionWrapper<DB, TB, CombinedSemiJoinFlag<Expressions>>


not()

not(expression): ExpressionWrapper<DB, TB, false>;

Negates an expression with boolean NOT.

Parameters

ParameterType
expressionExpressionWrapper<DB, TB, false>

Returns

ExpressionWrapper<DB, TB, false>


or()

or(expressions): ExpressionWrapper<DB, TB, false>;

Combines two or more expressions with boolean OR.

Parameters

ParameterType
expressionsreadonly [ExpressionWrapper<DB, TB, false>, ExpressionWrapper<DB, TB, false>, ExpressionWrapper<DB, TB, false>]

Returns

ExpressionWrapper<DB, TB, false>

Properties

PropertyModifierTypeDescription
betareadonlyBetaExpressionModule<DB, TB>Opt-in helpers for beta SOQL expression features.
fnreadonlyFilterFunctionModule<DB, TB>Function helpers available in this expression context.

On this page