Interface GroupConcatSeparatorStep

All Superinterfaces:

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

All Known Subinterfaces:

GroupConcatOrderByStep

public interface GroupConcatSeparatorStep
extends AggregateFunction<String>

MySQL's GROUP_CONCAT function.

Author:

Lukas Eder

See Also:

• DSL.listAgg(Field)

Method Summary

Modifier and Type	Method	Description
@NotNull AggregateFunction<String>	separator(String separator)	Specify the separator on the GROUP_CONCAT function.
@NotNull AggregateFunction<String>	separator(Field<String> separator)	Specify the separator on the GROUP_CONCAT function.

Methods inherited from interface AggregateFilterStep

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

Methods inherited from interface AggregateFunction

$filterWhere, keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy

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 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

separator

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE11G,POSTGRES,REDSHIFT,SPANNER,SQLITE,SQLSERVER2017,SYBASE,TERADATA,TRINO})
@NotNull AggregateFunction<String> separator(String separator)

Specify the separator on the GROUP_CONCAT function.

separator

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE11G,POSTGRES,REDSHIFT,SPANNER,SQLITE,SQLSERVER2017,SYBASE,TERADATA,TRINO})
@NotNull AggregateFunction<String> separator(Field<String> separator)

Specify the separator on the GROUP_CONCAT function.