{"action":"created","issue":{"url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/19","repository_url":"https://api.github.com/repos/orocrm/doctrine-extensions","labels_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/19/comments","events_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/19/events","html_url":"https://github.com/orocrm/doctrine-extensions/issues/19","id":131377091,"number":19,"title":"GROUP_CONCAT With string and not identifier","user":{"login":"Gawel1","id":5802344,"avatar_url":"https://avatars.githubusercontent.com/u/5802344?v=3","gravatar_id":"","url":"https://api.github.com/users/Gawel1","html_url":"https://github.com/Gawel1","followers_url":"https://api.github.com/users/Gawel1/followers","following_url":"https://api.github.com/users/Gawel1/following{/other_user}","gists_url":"https://api.github.com/users/Gawel1/gists{/gist_id}","starred_url":"https://api.github.com/users/Gawel1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gawel1/subscriptions","organizations_url":"https://api.github.com/users/Gawel1/orgs","repos_url":"https://api.github.com/users/Gawel1/repos","events_url":"https://api.github.com/users/Gawel1/events{/privacy}","received_events_url":"https://api.github.com/users/Gawel1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-04T15:11:10Z","updated_at":"2016-02-04T15:34:18Z","closed_at":null,"body":"Hello,\r\n\r\nIt seems to be not possible to use your GROUP_CONCAT DQL method with simple strings args : \r\n\r\nFor example, i want to generate JSON string with this instruction  : GROUP_CONCAT('{report:\"',r.label,'\", expiration_date:\"', ur.expiration_date, '\"}').\r\n\r\n "},"comment":{"url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/comments/179902900","html_url":"https://github.com/orocrm/doctrine-extensions/issues/19#issuecomment-179902900","issue_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/19","id":179902900,"user":{"login":"Gawel1","id":5802344,"avatar_url":"https://avatars.githubusercontent.com/u/5802344?v=3","gravatar_id":"","url":"https://api.github.com/users/Gawel1","html_url":"https://github.com/Gawel1","followers_url":"https://api.github.com/users/Gawel1/followers","following_url":"https://api.github.com/users/Gawel1/following{/other_user}","gists_url":"https://api.github.com/users/Gawel1/gists{/gist_id}","starred_url":"https://api.github.com/users/Gawel1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gawel1/subscriptions","organizations_url":"https://api.github.com/users/Gawel1/orgs","repos_url":"https://api.github.com/users/Gawel1/repos","events_url":"https://api.github.com/users/Gawel1/events{/privacy}","received_events_url":"https://api.github.com/users/Gawel1/received_events","type":"User","site_admin":false},"created_at":"2016-02-04T15:34:18Z","updated_at":"2016-02-04T15:34:18Z","body":"This MYSQL request give the result i want :\r\n\r\nSELECT 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;"}}