I am trying to use the Query Database node to execute a query that performs a GROUP_CONCAT() function on a field in a table in the mysql db. When I do I get the following error.ErrorsThere was a problem during the validation of the SQL statement with the databaseThe Column name GROUP_CONCAT(id) is invalid. Please use 'as' clause with function callsThe database returned ARV's that may not be supported. Message: GROUP_CONCAT(id)If I do as the error suggests and use the AS to give the table an alias I get the following error.ErrorsThere was a problem during the validation of the SQL statement with the databaseThe database returned ARV's that may not be supported. Message: idsIs there something I have to do to get the GROUP_CONCAT() function to work?...
OriginalPostID-34498
Discussion posts and replies are publicly visible