I am using the GROUP_CONCAT feature of SQL with a Generico filter, and I discovered that it truncates its output at 1024 characters by default. The maximum length is controlled by the session variable group_concat_max_len, so I would like to set it to a higher number and then run a select query in the Dataset field of my Generico filter (see the code example below). Unfortunately this code doesn't work, so I wonder is there an alternate way to achieve this effect?
SET SESSION group_concat_max_len = 2048;
SELECT DISTINCT
g.name AS "groupname",
GROUP_CONCAT(DISTINCT uid.data) AS "members" ...