How are you?
I’m having trouble using GROUP_CONCAT function, aside from MySQL to DB2 here.
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html # function_group-concat
I migrated an application of extensive and accurate data to use this collation of a single line to the records of the same person. The use would be through CDbCriteria, but there is no group_concat Criteria to be reserved only to MySQL
Some solutions have been created but these are not dynamic, so in my case does not have any use
Also researched Virtual Fields but these concatenate after a query has been performed, making it impossible I filter thousands of data and group them, bursting the PHP memory.
With a help of you intend to close this task this year end.