Is there a way to do a group_concat or string_agg on JPQL for a Yarg Report

[eparamo (Eduardo Paramo)]

I need to convert a whole list of records to a single value separated by comma.
this is very easy to do in postgres using string_agg. How can i do this using JPQL?

[krivopustov (Konstantin Krivopustov)]

You can use FUNCTION() operator in JPQL to call database functions.

[eparamo (Eduardo Paramo)]

@eparamo

need to convert a whole list of records to a single value separated by comma.
this is very easy to do in postgres using string_agg. How can i do this using JPQL?

Select Function(‘string_agg’, myField,’, ') as groupedRecords …

how would this function work with the groupped fields
does not work

[eparamo (Eduardo Paramo)]

Is it possible to get an example?

[eparamo (Eduardo Paramo)]

Is there an example?

[krivopustov (Konstantin Krivopustov)]

We don’t have an example of using this particular function.

But you can circumvent any limitations of JPQL if you use native SQL or even stored procedures as shown in this example project: jmix-samples/stored-procedures-sample at main · jmix-framework/jmix-samples · GitHub