CiviCRM Community Forums (archive)

I'm trying to find a way to use the API (OO version if possible) to list all the contacts in a certain group.  Using direct SQL, I would do something like this:

$result = db_query("
SELECT v.voice_part_4, c.display_name
FROM civicrm_contact c
JOIN civicrm_group_contact gc ON c.id=gc.contact_id
JOIN civicrm_group g ON gc.group_id=g.id
LEFT OUTER JOIN civicrm_value_constituent_information_1 v ON c.id=v.entity_id
WHERE gc.status='Added'
AND g.title='Current Singers'
AND c.is_deleted=0
ORDER BY FIND_IN_SET(SUBSTRING_INDEX(v.voice_part_4, ' ', 1), 'Soprano,Alto,Tenor,Bass'), v.voice_part_4, c.last_name
");

I'm not having luck so far, though.  Do I need to do an outer loop to get all the IDs for members of the group, then a fetch for each contact ID?  That seems much less efficient than the direct JOIN.  But I'm very new to the API, and I haven't found good documentation for it if there is any, so I may be missing a lot.

Thanks.

civicrm_api3("Contact","get", array(

$api = civicrm_api3 ();
$api->Contact->get (array("group_id"=>42));
print_r($api->values);

should do it

Erik - so that means I'll have an outer loop to find contact_ids, and an inner fetch for each ID?  The following does work but it's pretty slow:

require_once 'sites/all/modules/civicrm/api/class.api.php';
$api = new civicrm_api3( array('conf_path' => 'sites/default') );



$params = array(
    'group_id' => 6,
    'sequential' => 1,
    'rowCount' => 100000,
);

if ($api->GroupContact->Get($params)) {
    $vals = array();
    $members = $api->values;
    foreach ($members as $gm) {
        $api->Contact->GetSingle(array('contact_id' => $gm->contact_id));
        $c = $api->value;
        $vals[] = array($c->display_name, $c->contact_id);
    }
    print_r($vals);
} else {
    echo "No results.";
}


I can limit the fields returned, but it doesn't make much difference.  I think most of the time is taken by so many round trips to the database.

The other challenge I haven't figured out yet is how to get the civicrm_value_constituent_information_1 information - is there an API for that stuff?  Is that an additional call to the database? 

Hi,

It's easier/faster to api->Contact->Get (array("group"=>6, "return" => "sort_name,last_name"))

?

$api->Contact->Get (array ("return=>"sort_name,group,...")) returns the group,
 
array("group"=>42) filters

and you can combine the two. Not sure it was your question.