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)
return Roo.apply({
// id : (this.id + '-name').toLowerCase(),
header : "Group Membership",
- dataIndex : 'member_of_json',
+ dataIndex : 'member_of',
sortable : false,
- renderer : function(vv,p,r) {
- var v = vv ? JSON.parse(vv).join("\n") : '';
+ renderer : function(v,p,r) {
if(r.data.active != 1){
return String.format('<div style="text-decoration:line-through">{0}</div>', v).split("\n").join("<br/>");
}