CiviCRM Community Forums (archive)

Hello,

I need to be able to display the total number of contacts within each group on the Manage Groups Table (Rather than the group ID #).  Does anyone know the code to do this?  Any help would be greatly appreciated!!!

Maia Siber

Kurund, thank you for your quick response.. Your query works in the MySQL, but I'm having difficulty putting it in the Group.php file... Here's what I put in after the "visibility" column (named my totals column "members"):

$values[$object->id]['visibility'] = CRM_Contact_DAO_Group::tsEnum('visibility', $values[$object->id]['visibility']);
$values[$object->id]['members'] = SELECT count(DISTINCT contact_a.id) FROM civicrm_contact contact_a LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id WHERE ( civicrm_group_contact.group_id IN ( $object->id ) AND civicrm_group_contact.status IN ('Added') );

I get an error that says "Parse error: syntax error, unexpected T_STRING in .../CRM/sites/all/modules/civicrm/CRM/Group/Page/Group.php on line 267".

Do you know what the proper syntax is?