GROUP_CONCAT With string and not identifier about doctrine-extensions HOT 5 CLOSED

Hi, @Gawel1
In this case CONCAT must be used.

Group concat is equal to http://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html#function_group-concat

from doctrine-extensions.

The problem is there can be more than one line :
Example :
a table with :
a | b | c
a | d | e

I want in output : a | [{label1 : b, label2 : c},{label1 : e, label2 : e}] and group_concat works fine for do that.

from doctrine-extensions.

Please, provide your DQL

from doctrine-extensions.

This MYSQL request give the result i want :

SELECT u.email, CONCAT(u.first_name,' ', u.last_name) AS full_name, ur.is_active AS activated_licence, CONCAT('[', GROUP_CONCAT('{report:"',r.label,'", expiration_date:"', ur.expiration_date, '"}'), ']') AS licences FROM user u left join user_report ur ON ur.user_id=u.id left join report r ON ur.report_id=r.id WHERE u.company_id=%d AND u.status = AND u.role != %s GROUP BY u.email ORDER BY u.email;

from doctrine-extensions.

Hi, @Gawel1
Issue was found and fixed. Thank you for patience

from doctrine-extensions.