querydsl中实现sql的group_concat函数

import com.querydsl.core.QueryResults;
import com.querydsl.core.types.Order;
import com.querydsl.core.types.OrderSpecifier;
import com.querydsl.core.types.Predicate;
import com.querydsl.core.types.Projections;
import com.querydsl.core.types.dsl.Expressions;
import com.querydsl.core.types.dsl.StringTemplate;
import com.querydsl.jpa.impl.JPAQuery;
import com.querydsl.jpa.impl.JPAQueryFactory;

public QueryResults<ProductQueryVO> findProductList(List<Predicate> predicates,Pageable pageable) {
		StringTemplate stringTemplate = Expressions.stringTemplate("CONCAT(GROUP_CONCAT({0}),'')",QSupplier.supplier.supplierName);
		JPAQuery<ProductQueryVO> jpaQuery = queryFactory.select(Projections.fields(ProductQueryVO.class,
															stringTemplate.as("supplier"),
			   												QProduct.product.id,
			   												QProduct.product.productCode,
			   												QProduct.product.productName,
			   												QProduct.product.productType,
			   												QProduct.product.productPrice,
			   												QProduct.product.status))
		                                               	.from(QProduct.product)
		                                               	.leftJoin(QSupProduct.supProduct).on(QProduct.product.id.eq(QSupProduct.supProduct.productId))
		                                               	.leftJoin(QSupplier.supplier).on(QSupProduct.supProduct.supplierId.eq(QSupplier.supplier.id));
	   for (Predicate predicate : predicates) {
	   		jpaQuery.where(predicate);
	   }
	   jpaQuery.groupBy(QProduct.product.id).orderBy(new OrderSpecifier<Date>(Order.DESC,QProduct.product.createdTime)).offset(pageable.getOffset()).limit(pageable.getPageSize());

	   return jpaQuery.fetchResults();

参考：https://blog.csdn.net/qq_36400075/article/details/108509772