Using GROUP_CONCAT (MYSQL) in BO XI Universe

[Former Member]

Hi,

I have an error using group_concat in an universe (XI R3) : it works with a single table and a single text field query but does not work anymore :

- with a second aggregate field on the same table SUM(numeric field) + GROUP BY : the GROUP_CONCAT is automatically generated in the GROUP BY section as it should not

- with a second text field from another inner joinned table

Exception: DBD, [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-23~bpo40+1-log]Utilisation invalide de la clause GROUPState: HY000

Does anyone has ever used GROUP_CONCAT in a BO XI Universe ?

Thanks for your help.

Sebastien

[former_member188062]

Did you solve this? I am facing the same issue.

regards

Simon

[Former Member]

Hi all,

I am facing the same issue but can not find any solution.

Have you got any update on your side ?

Thanks