CiviCRM Community Forums (archive)

I'm using hook_civicrm_contactListQuery to modify the quick search, by replacing the query where the context is navigation:

if ($context == 'navigation') {
    $query = "SELECT cc.id as id, CONCAT_WS( ' :: ', sort_name, email, phone, street_address, city, ste.name, coy.name ) as data
        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 = '$name'
        OR postal_code LIKE '%$name%' AND cc.is_deleted = 0
        LIMIT 0,10";
}

This works correctly to generate a different list for the quick search, and you can click a specific result in the dropdown list. However, if you simply type in the quick search and hit enter, you get a backtrace with the error:

Sorry. A non-recoverable error has occurred.
cid (value: ) is not of the type Positive

It seems to still be using the overwritten query for this search, but expects a single value back. If I search for something where I know there's only one result, it works, but any other time it fails.Is there a way to specify a different query for the quick search list and the quick search form behaviour?

I have checked on my local 3.4.8 install and seems to be working fine. Is there a specific sequence to replicate this?

Kurund