Kysoql
ReferenceAPI referenceInterfaces

HavingExpressionBuilder

Generated API reference for HavingExpressionBuilder in @kysoql/core.

@kysoql/core / HavingExpressionBuilder

Expression helper passed to typed HAVING callbacks.

Type Parameters

Type ParameterDefault type
DB-
TB extends keyof DB-
GroupedBy extends string-
GroupingFields extends stringnever

Call Signature

HavingExpressionBuilder<Reference, Operator, Right>(
   lhs,
   op,
   rhs
): HavingExpressionWrapper<DB, TB, GroupedBy>;

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

Type Parameters

Type Parameter
Reference extends string
Operator extends | "=" | "!=" | OrderedComparisonOperator | "in" | "not in" | MultiSelectComparisonOperator | "like"
Right

Parameters

ParameterType
lhsReference & GroupedHavingFieldName<DB, TB, GroupedBy, Reference>
opOperator
rhsRight

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>

Call Signature

HavingExpressionBuilder<Output, Value, AllowedOperator, Operator, Right>(
   lhs,
   op,
   rhs
): HavingExpressionWrapper<DB, TB, GroupedBy>;

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

Type Parameters

Type Parameter
Output
Value
AllowedOperator extends ComparisonOperator
Operator extends ComparisonOperator
Right

Parameters

ParameterType
lhsAggregateFunctionExpression<Output, Value, AllowedOperator>
opOperator
rhsRight

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>

Call Signature

HavingExpressionBuilder<Output, Value, AllowedOperator, Identity, Operator, Right>(
   lhs,
   op,
   rhs
): HavingExpressionWrapper<DB, TB, GroupedBy>;

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

Type Parameters

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

Parameters

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

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>

Methods

and()

and(expressions): HavingExpressionWrapper<DB, TB, GroupedBy>;

Combines two or more expressions with boolean AND.

Parameters

ParameterType
expressionsreadonly [HavingExpressionWrapper<DB, TB, GroupedBy>, HavingExpressionWrapper<DB, TB, GroupedBy>, HavingExpressionWrapper<DB, TB, GroupedBy>]

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>


not()

not(expression): HavingExpressionWrapper<DB, TB, GroupedBy>;

Negates an expression with boolean NOT.

Parameters

ParameterType
expressionHavingExpressionWrapper<DB, TB, GroupedBy>

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>


or()

or(expressions): HavingExpressionWrapper<DB, TB, GroupedBy>;

Combines two or more expressions with boolean OR.

Parameters

ParameterType
expressionsreadonly [HavingExpressionWrapper<DB, TB, GroupedBy>, HavingExpressionWrapper<DB, TB, GroupedBy>, HavingExpressionWrapper<DB, TB, GroupedBy>]

Returns

HavingExpressionWrapper<DB, TB, GroupedBy>

Properties

PropertyModifierTypeDescription
fnreadonlyAggregateFunctionModule<DB, TB, GroupingFields>Function helpers available in this expression context.

On this page