Criteria API and JPQL API with GROUP BY and GROUP_CONCAT with DISTINCT / ORDER BY / SEPERATOR Support?
One of the solutions is to create a custom GROUP_CONCAT HQL function that is translated to SQL. Idea is to create function: group_concat(name, true, ‘ # ‘, name, ‘DESC’) 1: name of the column for aggregation 2: true\false use DISTINCT or not 3: the separator for concatenation 4: column name for ORDER BY 5: sorting … Read more