Cidlookup from postgresql

[goose2600]

Hi, looks like mod_cidlookup does not search in the fusionpbx contacts database, while searching in external source (like CNAM) works.

Here is the cidlookup.conf.xml:

    <!-- comment out sql to not setup a database (directory) lookup -->
    <param name="sql" value="
SELECT trim(v_contacts.contact_name_given || ' ' || v_contacts.contact_name_family || ' (' || v_contacts.contact_organization || ')') AS name, v_contact_phones.phone_number AS number
FROM v_contacts, v_contact_phones
WHERE v_contact_phones.contact_uuid = v_contacts.contact_uuid AND (v_contact_phones.phone_number = '${caller_id_number}' OR v_contact_phones.phone_number = '1${caller_id_number}')
LIMIT 1
      "/>

If I try to make a select from the command line, inserting a phone number (i.e. 0123456789) instead of variable, it works:

SELECT trim(v_contacts.contact_name_given || ' ' || v_contacts.contact_name_family || ' (' || v_contacts.contact_organization || ')') AS name, v_contact_phones.phone_number AS number
FROM v_contacts, v_contact_phones
WHERE v_contact_phones.contact_uuid = v_contacts.contact_uuid AND (v_contact_phones.phone_number = '0123456789' OR v_contact_phones.phone_number = '0123456789')
LIMIT 1;

Can someone help me?
Thanks!

 

[JamesBorne]

If you replace '${caller_id_number}' with 0123456789 in your cidlookup.conf.xml does it still work?

 

[goose2600]

JamesBorne, thank you.
I made the test you suggested and it does not work.

 

[Andrew Byrd]

Same issue . . . please let me know if anyone finds a fix. I thought the purpose of the CID lookup module was to check contacts in Fusion first.