Interface JSONArrayAggOrderByStep<J>

All Superinterfaces:

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

public interface JSONArrayAggOrderByStep<J>
extends JSONArrayAggNullStep<J>

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

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull JSONArrayAggNullStep<J>	orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull JSONArrayAggNullStep<J>	orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.

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 JSONArrayAggNullStep

absentOnNull, nullOnNull

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

orderBy

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,DUCKDB,H2,MARIADB_10_2,ORACLE12C,POSTGRES,SNOWFLAKE,SPANNER,TRINO,YUGABYTEDB})
@NotNull JSONArrayAggNullStep<J> orderBy(OrderField<?>... fields)

Add an ORDER BY clause to the function.

orderBy

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,DUCKDB,H2,MARIADB_10_2,ORACLE12C,POSTGRES,SNOWFLAKE,SPANNER,TRINO,YUGABYTEDB})
@NotNull JSONArrayAggNullStep<J> orderBy(Collection<? extends OrderField<?>> fields)

Add an ORDER BY clause to the function.