ReferenceAPI referenceInterfaces
SemiJoinSubqueryBuilder
Generated API reference for SemiJoinSubqueryBuilder in @kysoql/core.
@kysoql/core / SemiJoinSubqueryBuilder
Builder for the filtering portion of a semi-join subquery.
Extends
SemiJoinWhereBuilder<DB,TB,SemiJoinSubqueryBuilder<DB,OuterTB,OuterReference,TB>>
Type Parameters
| Type Parameter |
|---|
DB |
OuterTB extends keyof DB |
OuterReference extends string |
TB extends keyof DB |
Methods
$call()
$call<T>(func): T;Passes this builder to func and returns the callback result.
Type Parameters
| Type Parameter |
|---|
T |
Parameters
| Parameter | Type |
|---|---|
func | (qb) => T |
Returns
T
$if()
$if(condition, func): this;Conditionally applies a builder callback; when false, the runtime query is unchanged.
Parameters
| Parameter | Type |
|---|---|
condition | boolean |
func | (qb) => this |
Returns
this
clearWhere()
clearWhere(): this;Returns a builder with the WHERE predicate removed.
Returns
this
select()
select<SE>(selection): SelectedSemiJoinSubqueryBuilder<DB, OuterTB, OuterReference, TB>;Adds one or more typed selections to the query output.
Type Parameters
| Type Parameter |
|---|
SE extends string |
Parameters
| Parameter | Type |
|---|---|
selection | SE & SemiJoinSelectionFieldName<DB, OuterTB, OuterReference, TB, SE> |
Returns
SelectedSemiJoinSubqueryBuilder<DB, OuterTB, OuterReference, TB>
where()
Call Signature
where(expression): SemiJoinSubqueryBuilder;Parameters
| Parameter | Type |
|---|---|
expression | WhereExpressionFactory<DB, TB, false> |
Returns
SemiJoinSubqueryBuilder
Inherited from
SemiJoinWhereBuilder.whereCall Signature
where<RE, OP, RHS>(
lhs,
op,
rhs
): SemiJoinSubqueryBuilder;Type Parameters
| Type Parameter |
|---|
RE extends string |
OP extends | "=" | "!=" | OrderedComparisonOperator | "in" | "not in" | MultiSelectComparisonOperator | "like" |
RHS |
Parameters
| Parameter | Type |
|---|---|
lhs | RE & FilterableFieldName<DB, TB, RE> |
op | OP |
rhs | RHS |
Returns
SemiJoinSubqueryBuilder
Inherited from
SemiJoinWhereBuilder.where