Interface JSONArrayAggNullStep<T>

All Superinterfaces:

AggregateFilterStep<T>, Field<T>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, JSONArrayAggReturningStep<T>, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<T>, WindowBeforeOverStep<T>, WindowOverStep<T>

All Known Subinterfaces:

JSONArrayAggOrderByStep<J>

public interface JSONArrayAggNullStep<T>
extends JSONArrayAggReturningStep<T>

A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull JSONArrayAggReturningStep<T>	absentOnNull()	Exclude NULL values in output JSON.
@NotNull JSONArrayAggReturningStep<T>	nullOnNull()	Include NULL values in output JSON.

Methods inherited from interface AggregateFilterStep

filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere

Methods inherited from interface Field

add, add, as, as, as, as, asc, ascii, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, binaryLike, binaryLike, binaryLike, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, comment, comment, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, decode, decode, decode, decode, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, field, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, le, le, le, le, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBinaryLike, notBinaryLike, notBinaryLike, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nullsFirst, nullsLast, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, similarTo, similarTo, similarTo, similarTo, similarTo, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, sub, sub, substring, substring, substring, substring, subtract, subtract, times, times, touched, trim, unaryMinus, unaryPlus, upper

Methods inherited from interface JSONArrayAggReturningStep

returning

Methods inherited from interface Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Methods inherited from interface WindowOverStep

over, over, over, over, over

Method Details

nullOnNull

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DUCKDB,H2,MARIADB,MYSQL,ORACLE12C,POSTGRES,SNOWFLAKE,SPANNER,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,TRINO,YUGABYTEDB})
@NotNull JSONArrayAggReturningStep<T> nullOnNull()

Include NULL values in output JSON.

absentOnNull

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DUCKDB,H2,MARIADB,MYSQL,ORACLE12C,POSTGRES,SNOWFLAKE,SPANNER,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,TRINO,YUGABYTEDB})
@NotNull JSONArrayAggReturningStep<T> absentOnNull()

Exclude NULL values in output JSON.