I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is successfully running for the MySQL Dataflow. I have updated the dataset names to the aliases that the View uses. But I am getting an error. Of course the errors in SQL Editor for views are completely useless. I assume it is due to the GROUP_CONCAT function. Is it not supported for views? Below is the query I have successfully running for the MySQL Dataflow
SELECT
RECORDNO
,
Location ID (ARDetail)
,
Department ID (ARDetail)
,
Customer ID (ARRecord)
,
Invoice Number
,
GROUP_CONCAT(
CONCAT(date
,' - ',IFNULL(Name
,user
),': ',postBody
)
ORDER BY DATE(date
) DESC
SEPARATOR '\r\n') AS Notes
,
MAX(date
) AS Most Recent
FROM collection_notes_dataset
LEFT JOIN users
ON collection_notes_dataset
.user
= users
.User ID
GROUP BY
RECORDNO
,
Location ID (ARDetail)
,
Department ID (ARDetail)
,
Customer ID (ARRecord)
,
Invoice Number