Top Description Fields Constructors Methods
org.jooq.impl

pack-priv final Class JSONArrayAgg<J>

extends AbstractAggregateFunction<J>
implements JSONArrayAggOrderByStep<J>, QOM.JSONArrayAgg<J>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.JSONArrayAgg, org.jooq.impl.QOM.UOperator1, org.jooq.impl.QOM.UOperator, org.jooq.QueryPart, java.io.Serializable, org.jooq.AggregateFunction, org.jooq.AggregateFilterStep, org.jooq.WindowBeforeOverStep, org.jooq.Field, org.jooq.TableElement, org.jooq.Named, org.jooq.FieldOrConstraint, org.jooq.FieldOrRowOrSelect, org.jooq.FieldOrRow, org.jooq.OrderField, org.jooq.GroupField, org.jooq.SelectField, org.jooq.Typed, org.jooq.SelectFieldOrAsterisk, org.jooq.WindowOverStep, org.jooq.JSONArrayAggOrderByStep, org.jooq.JSONArrayAggNullStep, org.jooq.JSONArrayAggReturningStep
Static Imports
org.jooq.SQLDialect.MARIADB, .SQLDialect.MYSQL, org.jooq.impl.DSL.function, .DSL.groupConcat, .DSL.groupConcatDistinct, .DSL.inline, .JSONEntryImpl.jsonCastMapper, .JSONEntryImpl.jsonMerge, .Keywords.K_DISTINCT, .Names.N_ARRAY_AGG, .Names.N_GROUP_CONCAT, .Names.N_JSONB_AGG, .Names.N_JSON_AGG, .Names.N_JSON_ARRAYAGG, .Names.N_JSON_GROUP_ARRAY, .Names.N_JSON_QUOTE, .QOM.JSONOnNull.ABSENT_ON_NULL, .QOM.JSONOnNull.NULL_ON_NULL, .SQLDataType.BLOB, .SQLDataType.INTEGER, .SQLDataType.JSON, .SQLDataType.JSONB, .SQLDataType.VARCHAR, .Tools.BooleanDataKey.DATA_FORCE_CASE_ELSE_NULL

Deprecated

as a consequence of AbstractAggregateFunction, JSONArrayAggOrderByStep and QOM.JSONArrayAgg being deprecated. See corresponding docs for further information.

The JSON array constructor.
Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
pack-priv static final Set<SQLDialect>
EMULATE_WITH_GROUP_CONCAT

private QOM.JSONOnNull
onNull

private DataType<?>
returning

Inherited from org.jooq.impl.AbstractAggregateFunction:
argumentsASTERISKdistinctfilterfirstkeepDenseRankOrderByNO_SUPPORT_FILTERSUPPORT_DISTINCT_RVEwithinGroupOrderBy

Constructor Summary

AccessConstructor and Description
pack-priv
JSONArrayAgg(DataType<J> type, Field<?> arg, boolean distinct)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final Field<?>
$arg1()

Implements org.jooq.impl.QOM.UOperator1.$arg1.

Deprecated as a consequence of Field being deprecated.
public final Function1<? super Field<?>, ? extends QOM.JSONArrayAgg<J>>
$constructor()

Implements org.jooq.impl.QOM.UOperator1.$constructor.

public final QOM.JSONOnNull
$onNull()

Implements org.jooq.impl.QOM.JSONArrayAgg.$onNull.

public final DataType<?>
$returning()

Implements org.jooq.impl.QOM.JSONArrayAgg.$returning.

public final JSONArrayAgg<J>
absentOnNull()

Implements org.jooq.JSONArrayAggNullStep.absentOnNull.

Deprecated as a consequence of JSONArrayAgg being deprecated.
Exclude NULL values in output JSON.
public final void
accept(Context<?> ctx)

Overrides org.jooq.impl.AbstractAggregateFunction.accept.

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private void
acceptDistinct(Context<?> ctx)

private final void
acceptStandard(Context<?> ctx)

private final Field<?>
groupConcatEmulation(Context<?> ctx)

Deprecated as a consequence of Field being deprecated.
pack-priv static final Field<?>
groupConcatEmulationWithoutArrayWrappers(boolean distinct, Field<?> field, SortFieldList orderBy)

Deprecated as a consequence of Field being deprecated.
public final JSONArrayAgg<J>
nullOnNull()

Implements org.jooq.JSONArrayAggNullStep.nullOnNull.

Deprecated as a consequence of JSONArrayAgg being deprecated.
Include NULL values in output JSON.
public final JSONArrayAgg<J>
orderBy(OrderField<?>... fields)

Overrides org.jooq.impl.AbstractAggregateFunction.orderBy.

Implements org.jooq.JSONArrayAggOrderByStep.orderBy, org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Deprecated as a consequence of JSONArrayAgg being deprecated.
Add an ORDER BY clause to the function.
public final JSONArrayAgg<J>
orderBy(Collection<? extends OrderField<?>> fields)

Overrides org.jooq.impl.AbstractAggregateFunction.orderBy.

Implements org.jooq.JSONArrayAggOrderByStep.orderBy, org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Deprecated as a consequence of JSONArrayAgg being deprecated.
Add an ORDER BY clause to the function.
pack-priv static final <R extends Record> Select<R>
patchOracleArrayAggBug(Scope scope, SelectGroupByStep<R> select)

public final JSONArrayAgg<J>
returning(DataType<?> r)

Implements org.jooq.JSONArrayAggReturningStep.returning.

Deprecated as a consequence of JSONArrayAgg being deprecated.
Add a RETURNING clause to the JSON_ARRAYAGG function.
Inherited from org.jooq.impl.AbstractAggregateFunction:
$distinct$filterWhereacceptArguments0acceptArguments1acceptArguments2acceptArguments3acceptFilterClauseacceptFilterClauseacceptFunctionNameacceptOrderByacceptWithinGroupClauseapplyFilterdffilterWherefilterWherefilterWherefilterWherefilterWherefilterWherefilterWherefilterWherefofongetArgumentsoofowithinGroupOrderBywithinGroupOrderByxy

Field Detail

EMULATE_WITH_GROUP_CONCATback to summary
pack-priv static final Set<SQLDialect> EMULATE_WITH_GROUP_CONCAT
onNullback to summary
private QOM.JSONOnNull onNull
returningback to summary
private DataType<?> returning

Constructor Detail

JSONArrayAggback to summary
pack-priv JSONArrayAgg(DataType<J> type, Field<?> arg, boolean distinct)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Method Detail

$arg1back to summary
public final Field<?> $arg1()

Implements org.jooq.impl.QOM.UOperator1.$arg1.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@Override
$constructorback to summary
public final Function1<? super Field<?>, ? extends QOM.JSONArrayAgg<J>> $constructor()

Implements org.jooq.impl.QOM.UOperator1.$constructor.

Annotations
@Override
$onNullback to summary
public final QOM.JSONOnNull $onNull()

Implements org.jooq.impl.QOM.JSONArrayAgg.$onNull.

Annotations
@Override
$returningback to summary
public final DataType<?> $returning()

Implements org.jooq.impl.QOM.JSONArrayAgg.$returning.

Annotations
@Override
absentOnNullback to summary
public final JSONArrayAgg<J> absentOnNull()

Implements org.jooq.JSONArrayAggNullStep.absentOnNull.

Doc from org.jooq.JSONArrayAggNullStep.absentOnNull.

Deprecated

as a consequence of JSONArrayAgg being deprecated. See corresponding docs for further information.

Exclude NULL values in output JSON.

Annotations
@Override
acceptback to summary
public final void accept(Context<?> ctx)

Overrides org.jooq.impl.AbstractAggregateFunction.accept.

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
acceptDistinctback to summary
private void acceptDistinct(Context<?> ctx)
acceptStandardback to summary
private final void acceptStandard(Context<?> ctx)
groupConcatEmulationback to summary
private final Field<?> groupConcatEmulation(Context<?> ctx)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@SuppressWarnings:unchecked
groupConcatEmulationWithoutArrayWrappersback to summary
pack-priv static final Field<?> groupConcatEmulationWithoutArrayWrappers(boolean distinct, Field<?> field, SortFieldList orderBy)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

nullOnNullback to summary
public final JSONArrayAgg<J> nullOnNull()

Implements org.jooq.JSONArrayAggNullStep.nullOnNull.

Doc from org.jooq.JSONArrayAggNullStep.nullOnNull.

Deprecated

as a consequence of JSONArrayAgg being deprecated. See corresponding docs for further information.

Include NULL values in output JSON.

Annotations
@Override
orderByback to summary
public final JSONArrayAgg<J> orderBy(OrderField<?>... fields)

Overrides org.jooq.impl.AbstractAggregateFunction.orderBy.

Implements org.jooq.JSONArrayAggOrderByStep.orderBy, org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Doc from org.jooq.JSONArrayAggOrderByStep.orderBy.

Deprecated

as a consequence of JSONArrayAgg being deprecated. See corresponding docs for further information.

Add an ORDER BY clause to the function.

Annotations
@Override
orderByback to summary
public final JSONArrayAgg<J> orderBy(Collection<? extends OrderField<?>> fields)

Overrides org.jooq.impl.AbstractAggregateFunction.orderBy.

Implements org.jooq.JSONArrayAggOrderByStep.orderBy, org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Doc from org.jooq.JSONArrayAggOrderByStep.orderBy.

Deprecated

as a consequence of JSONArrayAgg being deprecated. See corresponding docs for further information.

Add an ORDER BY clause to the function.

Annotations
@Override
patchOracleArrayAggBugback to summary
pack-priv static final <R extends Record> Select<R> patchOracleArrayAggBug(Scope scope, SelectGroupByStep<R> select)
returningback to summary
public final JSONArrayAgg<J> returning(DataType<?> r)

Implements org.jooq.JSONArrayAggReturningStep.returning.

Doc from org.jooq.JSONArrayAggReturningStep.returning.

Deprecated

as a consequence of JSONArrayAgg being deprecated. See corresponding docs for further information.

Add a RETURNING clause to the JSON_ARRAYAGG function.

Annotations
@Override