Author Topic: Get all contacts with a given relationship type id (Read 1049 times)

dlats · April 05, 2012, 04:15:36 am

I tried
$params = array(
'contact_id_b' => $org_id,
'is_active' => 1,
'relationship_type_id' => 12 ,
'version' => '3',
);
$relm = civicrm_api('relationship', 'get', $params);

The error message says required key is missing: contact_id

Any ideas?

dlats · April 06, 2012, 12:27:37 pm

civicrm_initialize( ) ;

$sql = 'SELECT contact_id_a FROM civicrm_relationship WHERE relationship_type_id = %1 and contact_id_b = %2;';
$params = array(1 => array(12, 'Integer'), 2=>array(110,'Integer'));
$dao =& CRM_Core_DAO::executeQuery($sql, $params);
echo ' <br>';
while ($dao_res = $dao->fetch()) {
echo 'contact_id_a = '.$dao_res.'<BR>';

Erik Hommel · April 07, 2012, 03:16:20 am

The API is asking for a param with the name 'contact_id', you feed it 'contact_id_b'. Try using 'contact_id' instead?

CiviCRM Community Forums (archive)

News:

Author Topic: Get all contacts with a given relationship type id (Read 1049 times)

dlats

Get all contacts with a given relationship type id

dlats

Re: Get all contacts with a given relationship type id

Erik Hommel

Re: Get all contacts with a given relationship type id