GroupConcat equivalent in SQLSubquery querydsl

[pradeep gupta]

Hi all I am using nested quries in query dsl. One of the subquery is returning a single column. I want to concat all the rows of that column.

[timowest]

Querydsl SQL doesn't have direct support for group_concat, but you can express what you need through template expressions:

Expression<?> groupConcat = Expressions.template(String.class, "group_concat({0})", expr);