CiviCRM Community Forums (archive)

Hi,

We are using the API to search for display_name. However the API is looking for string matches in both display name AND email addresses. I.e.:

$params = array(
  'version' => 3,
  'sequential' => 1,
  'display_name' => 'mysearch',
  'contact_type' => 'Organization',
  'rowCount' => 10,
  'return' => 'display_name',
);
$result = civicrm_api('Contact', 'get', $params);

In the results we find organizations that have "mysearch" only in their email address, not in their display_name. How to avoid this? We already tried to disable searching for Email Address on "Settings - Search Preferences" page, however without any succeed.

Thanks in advance!

Try to search on organization_name (display name is a field that is generated from others (eg. first+last for individuals), it shouldn't touch email.

If I try that, I get only full matches (value='mysearch' instead of value LIKE '%mysearch%'). Is there a way to tell the API to search for "containing matches" instead of "full/exact matches"? We want to use the API to find contacts (Individuals and Organisations) that match a certain string.

Thanks! Using %this works fine:

$params = array(
  'version' => 3,
  'sequential' => 1,
  'organization_name' => '%mysearch%',
  'contact_type' => 'Organization',
  'rowCount' => 10,
  'return' => 'display_name,organization_name',
);
$result = civicrm_api('Contact', 'get', $params);

I will have a look to eu.tttp.qlookup too, but for now we're on the road again ;-)