Who Using Virtual Fields For Select With Group_Concat

Speaking staff.

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.

Hug friends.