X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_person.php;fp=DataObjects%2FCore_person.php;h=740fb5498e4a1cbe63b36b082c7073b61b97dced;hp=1e30d4ada274ea66576a2be2b4fe1261b957ad8b;hb=2be150527d6ada3cea26eba761c642ce1f056ad4;hpb=46145707edd41c81d5987a05196ede4253f3e6b5

diff --git a/DataObjects/Core_person.php b/DataObjects/Core_person.php
index 1e30d4ad..740fb549 100644
--- a/DataObjects/Core_person.php
+++ b/DataObjects/Core_person.php
@@ -1143,22 +1143,21 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
     function selectAddGroupMemberships()
     {
         $this->selectAdd("
-            CONCAT ('[',
-                COALESCE((
-                    SELECT
-                        GROUP_CONCAT( 
-                            JSON_QUOTE(core_group.name)
-                        )
-                    FROM
-                        core_group_member
-                    LEFT JOIN
-                        core_group
-                    ON
-                        core_group.id = core_group_member.group_id
-                    WHERE
-                        core_group_member.user_id = core_person.id
-                ), ''),
-            ']') as member_of_json");
+            
+            COALESCE((
+                SELECT
+                    GROUP_CONCAT( 
+                        core_group.name
+                    , '\n')
+                FROM
+                    core_group_member
+                LEFT JOIN
+                    core_group
+                ON
+                    core_group.id = core_group_member.group_id
+                WHERE
+                    core_group_member.user_id = core_person.id
+            ), '')  as member_of");
     }
     
     function setFromRoo($ar, $roo)