CiviCRM Community Forums (archive)

The code on http://en.flossmanuals.net/civicrm-developer-guide/api/ :

jQuery(document).ready(function($){
  $('#current_employer').crmAutocomplete({params:{contact_type:'Organization'}});
});
returns also Individuals on a Drupal 7 / CiviCRM 4.4.4 site that I am working on. The URL being fetched is

civicrm/ajax/rest?rowCount=35&json=1&entity=Contact&action=getquick&sequential=1&params[contact_type]=Organization&s=robinson&limit=25&timestamp=1401117553940&name=Robinson

In the API explorer, this URL

/civicrm/ajax/rest?entity=Contact&action=get&debug=1&sequential=1&json=1&contact_type=Organization&state_province_id=1644&sort_name=Rob

finds only two Organizations and if I remove the contact_type=Organization part:

/civicrm/ajax/rest?entity=Contact&action=get&debug=1&sequential=1&json=1&state_province_id=1644&sort_name=Rob

then it finds 25 Contacts, including the Individuals. So that part works.

But crmAutocomplete is not working for me.

URL is

/civicrm/ajax/rest?rowCount=35&json=1&entity=Contact&action=getquick&sequential=1&contact_type=Organization&s=robinson%2C+h&limit=25&timestamp=1401124341283&name=Robinson%2C+H

Still brings up Individuals.

joanne, I don't understand how your answer is supposed to help. I see no docs for crmAutocomplete on the wiki. Not via a search on the wiki itself nor via a search on Google.

Please read the full thread above. I am looking to get crmAutocomplete to work as advertised. If you know the format or a specific page with this information, please let us know.

I see in api/v3/Contact.php line 628:

  if (CRM_Utils_Array::value('org', $params)) {
    $where .= " AND contact_type = \"Organization\"";

I have no idea why that is the code, but if I use

$('#current_employer').crmAutocomplete({org:1});

it indeed works. Not a surprise.

Next mystery. My actual code is:

$('#current_employer').crmAutocomplete({org:1,state_province_id:$('#state_province-Primary').val()});
to get only Orgs from that state. The state_province_id is not included in the SQL query that is used in the code however.

So I added the second if statement here:

  if (CRM_Utils_Array::value('contact_sub_type', $params)) {
    $contactSubType = CRM_Utils_Type::escape($params['contact_sub_type'], 'String');
    $where .= " AND cc.contact_sub_type = '{$contactSubType}'";
  }

  if (CRM_Utils_Array::value('state_province_id', $params)) {
    $state_province_id = CRM_Utils_Type::escape($params['state_province_id'], 'Integer');
    $where .= " AND state_province_id = '{$state_province_id}'";
  }

at around line 662. This appears to work.

The only problem is that if you change the State dropdown it doesn't change the search parameters, due to how the parameters are passed statically to crmAutocomplete but anyhow this appears to be a step in the right direction.