CiviCRM Community Forums (archive)

I am very new to Drupal and CiviCRM, so please forgive me for me lack of understanding. I work for a small environmental non-profit (read 10 people in a office with no budget for IT help) that is trying to setup CiviCRM to handle our membership. We love what we have been able to do so far but really wish that we could quicksearch by external id.

I found a previous post that said this could be done with a hook. Great, so I followed the instructions for implementing a hook by uploading a .info and .module file and then enabling the module through Drupal. However, when I try to search by external id no results are returned and it says no name or email to match ...(external id).

Here is the code I have in the .module file. Disclaimer I am not a coder by trade and welcome all improvements. Actually I found this code through a Google Search (see: Mantra IT site) Thank you in advance for any help you can provide.

<?php

function hook_civicrm_contactListQuery( &$query, $name, $context, $id ) {
 if ($context == 'navigation') {
     $query = "SELECT cc.id as id, CONCAT_WS( ' :: ', sort_name,  email, phone, street_address, city, ste.name, coy.name ) as data, sort_name
               FROM civicrm_contact cc
               LEFT JOIN civicrm_email eml ON ( cc.id = eml.contact_id AND eml.is_primary = 1 )
               LEFT JOIN civicrm_phone phe ON ( cc.id = phe.contact_id AND phe.is_primary = 1 )
               LEFT JOIN civicrm_address sts ON ( cc.id = sts.contact_id AND sts.is_primary = 1)
               LEFT JOIN civicrm_state_province ste ON ( sts.state_province_id = ste.id )
               LEFT JOIN civicrm_country coy ON ( sts.country_id = coy.id )
               WHERE sort_name LIKE '%$name%' OR external_identifier LIKE '%$name%'
               AND cc.is_deleted = 0
               LIMIT 0,10";
    }
   
}