CiviCRM Community Forums (archive)

I'm looking at adding event as a cck field for events & it partially works.

I was hoping to use the api for the autocomplete but it would require a WHERE 'title' LIKE '%$string%' for it to work which doesn't seem possible - and yet I'm sure Xavier has used the API for just this sort of thing?

The code for contact is:

 
 function civicrm_cck_autocomplete($field_name, $string = '') {
  $references = _civicrm_cck_potential_references($field, $string);


    foreach ($references as $id => $row) {
        // Add a class wrapper for a few required CSS overrides.
        $matches["{$row['title']} [cid:{$id}]"] = '<div class="reference-autocomplete">'. $row['rendered'] . '</div>';
    }

}
    drupal_json($matches);
_civicrm_cck_potential_references calls a long drawn out search effort (and contact is a more complicated entity) so I was hoping there was a simpler api-v3-way

if ($field['type'] == 'civicrm_cck_event'){
  require_once 'api/api.php';
  $result = civicrm_api('Event','Get',array('version' => 3,'title' => '%' . $string . '%', 'return.title' => 1, ) );
  if ($result['is_error']==0){
    $references= $result['values'];
    $references['rendered'] = $references['title'];
  }
    foreach ($references as $id => $row) {
        // Add a class wrapper for a few required CSS overrides.
        $matches["{$row['title']} [cid:{$id}]"] = '<div class="reference-autocomplete">'. $row['title'] . '</div>';
    }
drupal_json($matches);

 // nb the function civicrm_error() is a v2 function so I didn't use it - we should probably move it into api.php as it is generic?

Hey, any response on this?

I want to extend the (cck) field integration module to cover other data types using the api for autocomplete fields. I really want to be able to do LIKE '%str%' against the api in order for this to work (and I think the api should support searching).

If this isn't an approach we can make progress on I'll probably drop the idea of extending cck / rules integration & just do a custom bit of code for the specific use case but it feels like that would be a shame as I was making progress on using Rules integration to get Civi interacting better with organic groups.